Lalaine Ejanda

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.

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.

Add and Remove Share-based Databases from Snowflake Create a Direct Share and Add Consumers to the Share Join an Exchange as a Provider and Consumer Use the Marketplace to find and request Data Build two shares that form a data enhancement shareback