<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
).
SNOWFLAKE_ACCOUNT
- The ID of the target Snowflake account, represented by --account
(CLI) or account
(Python).
SNOWFLAKE_USER
- The name of the target Snowflake user, represented by --user
(CLI) or user
(Python).
SNOWFLAKE_PASSWORD
- The user’s password, represented by --password
(CLI) or password
(Python).
SNOWFLAKE_ROLE
- The target role for the user, represented by --role
(CLI) or role
(Python).
SNOWFLAKE_HOST
- The hostname for the target Snowflake warehouse, represented by --host
(CLI) or host
(Python).
SNOWFLAKE_PORT
- The warehouse’s port number, represented by --port
(CLI) or port
(Python). The default is 443
if not otherwise specified.
SNOWFLAKE_DATABASE
- The name of the target Snowflake database, represented by --database
(CLI) or database
(Python).
SNOWFLAKE_SCHEMA
- The name of the target schema in the database, represented by --schema
(CLI) or schema
(Python).
SNOWFLAKE_TABLE
- The name of the target table in the schema, represented by --table-name
(CLI) or table_name
(Python). For the destination connector, the default is elements
if not otherwise specified.
SNOWFLAKE_RECORD_ID_KEY
- The name of the column in the table that uniquely identifies each record, represented by:
--id-column
(CLI) or id_column
(Python).--record-id-key
(CLI) or record_id_key
(Python). For the destination connector, the default is record_id
if not otherwise specified.--partition-by-api
option (CLI) or partition_by_api
(Python) parameter to specify where files are processed:
--partition-by-api
(CLI) or partition_by_api
(Python), or explicitly specify partition_by_api=False
(Python).
Local file processing does not use an Unstructured API key or API URL, so you can also omit the following, if they appear:
--api-key $UNSTRUCTURED_API_KEY
(CLI) or api_key=os.getenv("UNSTRUCTURED_API_KEY")
(Python)--partition-endpoint $UNSTRUCTURED_API_URL
(CLI) or partition_endpoint=os.getenv("UNSTRUCTURED_API_URL")
(Python)UNSTRUCTURED_API_KEY
and UNSTRUCTURED_API_URL
--partition-by-api
(CLI) or partition_by_api=True
(Python).
Unstructured also requires an Unstructured API key and API URL, by adding the following:
--api-key $UNSTRUCTURED_API_KEY
(CLI) or api_key=os.getenv("UNSTRUCTURED_API_KEY")
(Python)--partition-endpoint $UNSTRUCTURED_API_URL
(CLI) or partition_endpoint=os.getenv("UNSTRUCTURED_API_URL")
(Python)UNSTRUCTURED_API_KEY
and UNSTRUCTURED_API_URL
, representing your API key and API URL, respectively.https://api.unstructuredapp.io/general/v0/general
, which is the API URL for the Unstructured Partition Endpoint. However, you should always use the URL that was provided to you when your Unstructured account was created. If you do not have this URL, contact Unstructured Sales at sales@unstructured.io.If you do not have an API key, get one now.If the Unstructured API is self-hosted, the process
for generating Unstructured API keys, and the Unstructured API URL that you use, are different.
For details, contact Unstructured Sales at
sales@unstructured.io.