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.
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.Last modified 3mo ago