Upsolver SQLake
Search…
⌃K

Data ingestion

Before ingesting your data, you should ensure that you have the proper connection to read from your data source as well as a metastore connection and a corresponding a cloud storage location for your staging table.
See: Connectors
Once you have set up the connectors that you need, you can define the staging table to copy your data into using the CREATE TABLE command.
Then you can create a COPY FROM job that reads your data and writes it into that staging table. SQLake ingestion jobs are able automatically infer the schema and populate the column names and types in the table.

Learn more about reading from each connection type