Jonathan Lee Long

Convert Timezones with Snowflake Date/Time Data Types Map Approximate End User Locations via IP Addresses Create & Run SNOWFLAKE TASKS and MERGE Statements. Create a STREAM for Change Data Capture Functionality. Create a SNOWPIPE for Event-Driven, Continuous Loading.

Create, edit and use Snowflake STAGE objects. Query STAGED DATA prior to load. Query GeoSpatial Data and use GeoSpatial Functions. Create EXTERNAL TABLES and MATERIALIZED VIEWS. Design, build, and call USER DEFINED FUNCTIONS. Work with PARQUET data and describe ICEBERG TABLES.

Create UI entry forms in Streamlit to collect data Write Python to insert collected data into Snowflake tables Set Up GitHub to edit and manage code Make REST API calls to collect data Write Python to retrieve data from Snowflake tables

Manage and Create Listings via Provider Studio Estimate and Monitor Snowflake Costs Act as Org Admin to Create and Manage Accounts Create a User-Defined Table Function (UDTF) Use the Marketplace and Collaboration Tools to Cut Costs and Improve Operational Efficiency.

Create, edit, and load Snowflake TABLES Create, edit, and use Snowflake FILE FORMATS Create, edit, and use Snowflake COMPUTE resources Create, edit, and use COPY INTO statements Transform, parse and load both CSV and JSON data