Steps to Import Data
With Import Data, additional data can be added to data warehouses for exploration, cleansing, and transformation using Infoworks AI. Supported file formats include CSV, XLSX, and XLS, with a maximum upload size of 200MB per file. The home screen displays a list of imported data files along with details such as warehouse name, database, schema, file name, import job status, and record count.
Upload a File
At the top of the page, files can be uploaded by either dragging and dropping a data file or clicking the card to select a file. Once selected, the file will upload and proceed to the configuration of the new table.
Configuration
Here, configure the details of the new table generated from the imported file.
| Field | Description |
|---|---|
| Table Name | Specify a name for the table. Only letters (a-z and A-Z), numbers (0-9), underscores (_) are allowed in the table name. |
| Import to Data Warehouse | Select the data warehouse connection to used. |
| Import to Database | The name of the database to which the data will be imported. This field will automatically populate with the Target Database entered during the data warehouse connection configuration. |
| Import to Schema | The name of the database schema. This field will automatically populate with the Target Schema entered during the data warehouse connection configuration. |
| Headers | A preview of the new table will be displayed, including a sample of records. Review the header names and data types for accuracy and make any necessary edits. Only letters (a-z, A-Z), numbers (0-9), underscores (_), and the dollar sign ($) are allowed in the column names.
|
| Import Data | Click this button to start creating the table in the warehouse and import the data into the table. You will be redirected to the 'Your Imported Tables' page, where the status of the import job will be displayed, indicating whether the job is Running, Failed, or Successful. |
Step 3: Users can review and adjust the column names based on their requirements. The original column names from the file will be displayed, and you have the option to:
- Edit column names.
- Change data types of the columns.
Step 4: After reviewing or modifying the columns, click on Import Data button. It will launch a job to import the csv data to snowflake.
Step 5: User will be redirected to the Import Data page where the list of jobs will displayed along with the status.
Required Privileges for Importing Data into Snowflake
| Resource | Required Privileges | Purpose | Grant Command |
|---|---|---|---|
| Database | USAGE | Allows referencing the database. | GRANT USAGE ON DATABASE <database_name> TO ROLE <role_name>; |
| Database (if it doesn't exist) | CREATE DATABASE | Allows creating a new database. | GRANT CREATE DATABASE ON ACCOUNT TO ROLE <role_name>; |
| Schema | USAGE, CREATE TABLE | Allows referencing schema and creating tables. | GRANT USAGE, CREATE TABLE ON SCHEMA <database_name>.<schema_name> TO ROLE <role_name>; |
| Schema (if it doesn't exist) | CREATE SCHEMA | Allows creating a new schema in a database. | GRANT CREATE SCHEMA ON DATABASE <database_name> TO ROLE <role_name>; |