<service-user-name>
with some name for the service user.<default-role-name>
with the name of any default role for the service user to use.<my-user>
, including their login_name
value representing their login name:
0.0.0.0/0
, and then press Enter.
0.0.0.0/0
value allows all IP addresses to access the Snowflake account.
You can specify a more specific IP address range if you prefer. However, this more specific IP address range
will apply to all users, including the user for which you created the PAT.<my-user>
, including their login_name
value representing their login name:
CREATE DATABASE
privilege at the current account level; and USAGE
privilege on the warehouse that is used to create the database.USAGE
privilege on the database and the warehouse that is used to create the schema; and CREATE SCHEMA
on the database.USAGE
privilege on the database and schema and the warehouse that is used to create the table; and CREATE TABLE
on the schema.USAGE
privilege on the database and schema and the warehouse that is used to write to the table; and INSERT
on the table.USAGE
privilege on the database and schema and the warehouse that is used to write to the table; and SELECT
on the table.type
of SNOWFLAKE_DEPLOYMENT
:
<database_name>
in the current account:
<schema_name>
in the datbase named
<database_name>
in the current account:
CREATE TABLE
statement, replace the following placeholders with the appropriate values:
<database_name>
: The name of the target database in the Snowflake account.<schema_name>
: The name of the target schema in the database.<number-of-dimensions>
: The number of dimensions for any embeddings that you plan to use. This value must match the number of dimensions for any embeddings that areRECORD_ID
).
<name>
(required) - A unique name for this connector.
<account>
(required): The target Snowflake account’s identifier.
<role>
(required): The name of the Snowflake role that the user belongs to. This role must have the appropriate access to the target Snowflake warehouse, database, schema, and table.
<user>
(required): The target Snowflake user’s login name (not their username).
<programmatic-access-token>
(required): The user’s programmatic access token (PAT).
<host>
(required): The hostname of the target Snowflake warehouse.
<port>
(required): The warehouse’s port number. The default is 443
if not otherwise specified.
<database>
(required): The name of the target Snowflake database.
<schema>
(required): The name of the target Snowflake schema within the database.
<table_name>
: The name of the target Snowflake table within the database’s schema. For the destination connector, the default is elements
if not otherwise specified.
<columns>
(source connector only): A comma-separated list of columns to fetch from the table. By default, all columns are fetched unless otherwise specified.
<id-column>
(required, source connector only): The name of the column that uniquely identifies each record in the table.
<record-id-key>
(destination connector only): The name of the column that uniquely identifies each record in the table. The default is record_id
if not otherwise specified.
<batch-size>
(required): The maximum number of rows to fetch for each batch. The default is 50
if not otherwise specified.