Snowflake replication and failover
PRIMARY ----------------------------------------------------------------------------------------------------------- -- All commands/statements can be found via the link in the Video Description -- ----------------------------------------------------------------------------------------------------------- -- Create Database & Schema USE ROLE accountadmin ; CREATE DATABASE employee_db ; use employee_db ; CREATE SCHEMA employee_schema ; -- Create Tables CREATE TABLE employee_schema . employee ( employee_id INT PRIMARY KEY , first_name VARCHAR ( 50 ), last_name VARCHAR ( 50 ), email VARCHAR ( 100 ) ); CREATE TABLE employee_schema . employee_salary ( employee_id INT PRIMARY KEY , basic DECIMAL ( 10 , 2 ), allowances DECIMAL ( 10 , 2 ), deductions DECIMAL ( 10...