Create a landing data table in Snowflake

Learn how to create a landing table in Snowflake to store all incoming data from Reltio.

Before you create a landing data table in Snowflake, you must have created a database schema. For more information, see topic Create a Snowflake schema.

A Snowflake landing table is an intermediate storage area used for data processing during the extract, transform and load (ETL) process. The data landing table sits between the Reltio data and the object type staging tables in Snowflake. Create a Snowflake landing data table to store raw JSON data from Reltio.

To create a target data table in your Snowflake environment:

In the Snowflake application worksheet area, create a new SQL worksheet.
In the SQL worksheet, run this command:
```
CREATE TABLE "<database_name>"."<schema_name>"."<landingtable_name>" 
("uri" VARCHAR, "version" NUMBER, "timestamp" NUMBER(13,0), "deleted" BOOLEAN, "linked" BOOLEAN, "objectType" VARCHAR, "type" VARCHAR, "json" VARIANT, "ingestTime" TIMESTAMP) cluster by ("objectType", "type");
```
where:
- <database_name>: Is the name of the database you created in Create a Snowflake database.
- <schema_name>: Is the name of the schema you created in Create a Snowflake schema.
- <landingtable_name>: Is the name of this landing data table you're creating.
  
  Tip: Take note of this value. You'll need it when you Create a Snowpipe in Snowflake (Azure).
In the SQL worksheet, view the Successfully created notification message.

For general information, see Create table in the Snowflake SQL Command Reference.

Accelerate the Value of Data

Create a landing data table in Snowflake

Footer