Now that we understand how a data warehouse works, let's talk about how we get data into the data warehouse. In Stitch, data sources are called integrations, which is where data is pulled from. Data can be pulled in through a direct connection or via a piece of software called an API, or Application Programming Interface. APIs allow for more security, control, and flexibility over the data sent through the Stitch.
In most cases, setting up an integration in Stitch is as easy as simply entering your account credentials. After setup is complete, all available tables will begin syncing to your data warehouse.
There are two types of data sources: databases and SaaS. Databases are sources like MySQL, Microsoft SQL, and PostgreSQL.
So, what does the entire data process, from event to exploration, look like in Stitch? This won't look the same for everyone, but here's a general overview:
Now that you understand where your data comes from, let's move on to the interesting things you can do with the data that lives in your data warehouse.