Snowflake private listing, marketplace listing, and data exchange reader accounts
Provider: -- Create Database CREATE DATABASE exchange_rates_db ; -- Use Database USE DATABASE exchange_rates_db ; -- Create Schema CREATE SCHEMA exchange_rates_schema ; -- Create Table CREATE TABLE exchange_rates_schema . exchange_rates ( date DATE , currency_from VARCHAR ( 3 ), currency_to VARCHAR ( 3 ), exchange_rate NUMBER ); -- Insert Rows INSERT INTO exchange_rates_schema . exchange_rates ( date , currency_from , currency_to , exchange_rate ) VALUES ( '2023-06-01' , 'USD' , 'EUR' , 0 . 89 ), ( '2023-06-01' , 'USD' , 'GBP' , 0 . 78 ), ( '2023-06-01' , 'USD' , 'JPY' , 109 . 50 ), ( '2023-06-01' , 'EUR' , 'USD' , 1 . 12 ), ( '2023-06-01' , 'GBP' , 'USD' , 1 . 28 ), ( '2023-06-01' , 'JPY' , 'USD' , 0 . 0091 ), ( '2023-06-01' , 'EUR' , 'GBP' , 0 . 91 ), ( ...