docs.snowflake.com

Authenticate to Snowflake programmatically using RSA key-pair authentication and a signed JWT bearer token

Create a Snowflake external access integration (network rule plus secret) so a Python UDF or stored procedure can call an outbound HTTPS API

Call Snowflake Cortex AISQL functions (AI_COMPLETE, AI_CLASSIFY, AI_SENTIMENT, AI_SUMMARIZE_AGG) from SQL to enrich table data with LLM output

Share Snowflake tables and secure views with a consumer account using a secure share, or publish the same share as a listing

Recover and branch Snowflake data using Time Travel (AT/BEFORE), UNDROP, and zero-copy CLONE

Unload Snowflake query results to cloud storage with COPY INTO location, controlling file splitting, compression, and single-file output

Bulk load files from an external S3 stage into a Snowflake table using a storage integration, external stage, file format, and COPY INTO

Create a Snowflake row access policy that filters table rows per tenant or role using a mapping-table lookup

Apply a Snowflake dynamic data masking policy to a column so sensitive values are redacted based on the querying role

Design a Snowflake RBAC model: create custom roles, grant object and future privileges, build a role hierarchy, and transfer ownership safely

Lock down Snowflake login by combining a network policy (IP/network-rule allow-listing) with an authentication policy requiring MFA

Execute SQL against Snowflake via the SQL REST API v2 (POST /api/v2/statements) with async execution, status polling, and result pagination

Enable Snowflake Query Acceleration Service to offload large scans from a warehouse without resizing it

Create a Snowflake resource monitor to cap warehouse credit spend and auto-suspend at a threshold

Snowflake Streams and Tasks: build an automated incremental processing pipeline

Define a Snowflake semantic view using SQL DDL to expose business metrics and dimensions for use with Cortex Analyst

Create a Snowflake semantic view using CREATE SEMANTIC VIEW DDL with tables, relationships, dimensions, and metrics

Use the Snowflake Horizon Iceberg REST endpoint to read a Snowflake-managed Iceberg table from an external engine

Compare and implement Snowflake Snowpipe Streaming versus classic Snowpipe for low-latency ingestion

Configure Snowflake dynamic tables with incremental and full refresh modes for automated pipeline materialization

Snowflake SQL API submit statement