Storing Historical Data (DB Questions)

I recently stood up a weather station and got the data flowing into HA. I’d like to do two things:

  • Store the data long-term (years) so that I can reference it and possibly use it for future projects
  • Build a weather dashboard and use data from the last ~30 days

While I’m tech savvy, I’m inexperienced with databases, so pretty much all of my questions are database ones.

I saw that InfluxDB is natively supported by HA and that seems like a good route to go. So…

  1. When setting up something like InfluxDB, do I have to configure the DB schema for the data being ingested? ie columns(temp, wind speed, wind direction, humidity, etc, etc)?
  2. How do I then use that data in things like graph-cards?
  3. If I have a DB containing ~2 years worth of data, will queries become slow, leading to issues with a dashboard? If so, I have the resources to host a DB elsewhere on my network while keeping a DB of ~30 days on HA, but not sure how to go about (1) piping out the data and (2) limiting the HA DB to X days of data.

TYIA