SNOWFLAKE CERTIFIED
Using Cortex AISQL with Multimodal Data
create or replace file format csvformat
skip_header = 1
field_optionally_enclosed_by = '"'
type = 'CSV';
-- Emails table
create or replace stage emails_data_stage
file_format = csvformat
url = 's3://sfquickstarts/sfguide_getting_started_with_cortex_aisql/emails/';
create or replace TABLE EMAILS (
USER_ID NUMBER(38,0),
TICKET_ID NUMBER(18,0),
CREATED_AT TIMESTAMP_NTZ(9),
CONTENT VARCHAR(16777216)
create or replace file format csvformat
skip_header = 1
field_optionally_enclosed_by = '"'
type = 'CSV';
-- Emails table
create or replace stage emails_data_stage
file_format = csvformat
url = 's3://sfquickstarts/sfguide_getting_started_with_cortex_aisql/emails/';
create or replace TABLE EMAILS (
USER_ID NUMBER(38,0),
TICKET_ID NUMBER(18,0),
CREATED_AT TIMESTAMP_NTZ(9),
CONTENT VARCHAR(16777216)
create or replace file format csvformat
skip_header = 1
field_optionally_enclosed_by = '"'
type = 'CSV';
-- Emails table
create or replace stage emails_data_stage
file_format = csvformat
url = 's3://sfquickstarts/sfguide_getting_started_with_cortex_aisql/emails/';
create or replace TABLE EMAILS (
USER_ID NUMBER(38,0),
TICKET_ID NUMBER(18,0),
CREATED_AT TIMESTAMP_NTZ(9),
CONTENT VARCHAR(16777216)
create or replace file format csvformat
skip_header = 1
field_optionally_enclosed_by = '"'
type = 'CSV';
-- Emails table
create or replace stage emails_data_stage
file_format = csvformat
url = 's3://sfquickstarts/sfguide_getting_started_with_cortex_aisql/emails/';
create or replace TABLE EMAILS (
USER_ID NUMBER(38,0),
TICKET_ID NUMBER(18,0),
CREATED_AT TIMESTAMP_NTZ(9),
CONTENT VARCHAR(16777216)
create or replace file format csvformat
skip_header = 1
field_optionally_enclosed_by = '"'
type = 'CSV';
-- Emails table
create or replace stage emails_data_stage
file_format = csvformat
url = 's3://sfquickstarts/sfguide_getting_started_with_cortex_aisql/emails/';
create or replace TABLE EMAILS (
USER_ID NUMBER(38,0),
TICKET_ID NUMBER(18,0),
CREATED_AT TIMESTAMP_NTZ(9),
CONTENT VARCHAR(16777216)
create or replace file format csvformat
skip_header = 1
field_optionally_enclosed_by = '"'
type = 'CSV';
-- Emails table
create or replace stage emails_data_stage
file_format = csvformat
url = 's3://sfquickstarts/sfguide_getting_started_with_cortex_aisql/emails/';
create or replace TABLE EMAILS (
USER_ID NUMBER(38,0),
TICKET_ID NUMBER(18,0),
CREATED_AT TIMESTAMP_NTZ(9),
CONTENT VARCHAR(16777216)
create or replace file format csvformat
skip_header = 1
field_optionally_enclosed_by = '"'
type = 'CSV';
-- Emails table
create or replace stage emails_data_stage
file_format = csvformat
url = 's3://sfquickstarts/sfguide_getting_started_with_cortex_aisql/emails/';
create or replace TABLE EMAILS (
USER_ID NUMBER(38,0),
TICKET_ID NUMBER(18,0),
CREATED_AT TIMESTAMP_NTZ(9),
CONTENT VARCHAR(16777216)
create or replace file format csvformat
skip_header = 1
field_optionally_enclosed_by = '"'
type = 'CSV';
-- Emails table
create or replace stage emails_data_stage
file_format = csvformat
url = 's3://sfquickstarts/sfguide_getting_started_with_cortex_aisql/emails/';
create or replace TABLE EMAILS (
USER_ID NUMBER(38,0),
TICKET_ID NUMBER(18,0),
CREATED_AT TIMESTAMP_NTZ(9),
CONTENT VARCHAR(16777216)
create or replace file format csvformat
skip_header = 1
field_optionally_enclosed_by = '"'
type = 'CSV';
-- Emails table
create or replace stage emails_data_stage
file_format = csvformat
url = 's3://sfquickstarts/sfguide_getting_started_with_cortex_aisql/emails/';
create or replace TABLE EMAILS (
USER_ID NUMBER(38,0),
TICKET_ID NUMBER(18,0),
CREATED_AT TIMESTAMP_NTZ(9),
CONTENT VARCHAR(16777216)
create or replace file format csvformat
skip_header = 1
field_optionally_enclosed_by = '"'
type = 'CSV';
-- Emails table
create or replace stage emails_data_stage
file_format = csvformat
url = 's3://sfquickstarts/sfguide_getting_started_with_cortex_aisql/emails/';
create or replace TABLE EMAILS (
USER_ID NUMBER(38,0),
TICKET_ID NUMBER(18,0),
CREATED_AT TIMESTAMP_NTZ(9),
CONTENT VARCHAR(16777216)
create or replace file format csvformat
skip_header = 1
field_optionally_enclosed_by = '"'
type = 'CSV';
-- Emails table
create or replace stage emails_data_stage
file_format = csvformat
url = 's3://sfquickstarts/sfguide_getting_started_with_cortex_aisql/emails/';
create or replace TABLE EMAILS (
USER_ID NUMBER(38,0),
TICKET_ID NUMBER(18,0),
CREATED_AT TIMESTAMP_NTZ(9),
CONTENT VARCHAR(16777216)
create or replace file format csvformat
skip_header = 1
field_optionally_enclosed_by = '"'
type = 'CSV';
-- Emails table
create or replace stage emails_data_stage
file_format = csvformat
url = 's3://sfquickstarts/sfguide_getting_started_with_cortex_aisql/emails/';
create or replace TABLE EMAILS (
USER_ID NUMBER(38,0),
TICKET_ID NUMBER(18,0),
CREATED_AT TIMESTAMP_NTZ(9),
CONTENT VARCHAR(16777216)
Overview
Cortex AISQL reimagines SQL into an AI query language for multimodal data, bringing powerful AI capabilities directly into Snowflake's SQL engine. It enables users to build scalable AI pipelines across text, images, and audio using familiar SQL commands.
Cortex AISQL democratizes AI-powered analytics across the enterprise.
Cortex AISQL bridges the traditional divide between structured and unstructured data analysis, eliminating the need for separate tools and specialized skills.
This solution was created by an in-house Snowflake expert and has been verified to work with current Snowflake instances as of the date of publication.
Solution not working as expected? Contact our team for assistance.