Snowflake Option

The Datalogz application uses OLTP and OLAP databases to optimize performance and scalability between the two workloads. Teams can choose to run their BI Warehouse using Snowflake following the steps:
Snowflake

Minimum
- Compute: X-Small Warehouse
- Storage: Pay as you go
Estimated Cost as of 2/1/2023 assuming 10 users: $600 / mo.
Recommended
- Compute: Small Warehouse
- Storage: Pay as you go
Estimated Cost as of 2/1/2023 assuming 10 users: $1000 / mo.
Total Estimated Cost: $600 - $1000 / mo.
Object Creation

Snowflake

Warehouse DB Name: datalogz_wh
The following instructions make reference to POWERBI, but this can be replaced with either TABLEAU or LOOKER as appropriate.
-- Setup the BI Warehouse Database (OLAP - App Workflows)
USE ROLE ACCOUNTADMIN;
CREATE WAREHOUSE IF NOT EXISTS DATALOGZ_BIOPS WITH WAREHOUSE_SIZE='X-SMALL';

USE ROLE SYSADMIN;  -- whichever role you want to own this database
CREATE DATABASE DATALOGZ_WH;

CREATE ROLE IF NOT EXISTS DATALOGZ_DIAGNOSTICS_ADMIN_ROLE;
CREATE ROLE IF NOT EXISTS DATALOGZ_GATEWAY_ADMIN_ROLE;
CREATE ROLE IF NOT EXISTS WRITE_USER_ROLE;
CREATE ROLE IF NOT EXISTS READ_USER_ROLE;

-- GRANT CREATE USER ON ACCOUNT TO ROLE WRITE_USER_ROLE; -- only required for hosting SaaS deployment
-- GRANT ROLE USERADMIN TO ROLE WRITE_USER_ROLE;
GRANT ROLE WRITE_USER_ROLE TO ROLE DATALOGZ_GATEWAY_ADMIN_ROLE;

GRANT USAGE ON WAREHOUSE DATALOGZ_BIOPS TO ROLE DATALOGZ_DIAGNOSTICS_ADMIN_ROLE;
GRANT USAGE ON WAREHOUSE DATALOGZ_BIOPS TO ROLE DATALOGZ_GATEWAY_ADMIN_ROLE;
GRANT USAGE ON WAREHOUSE DATALOGZ_BIOPS TO ROLE USERADMIN;
GRANT USAGE ON WAREHOUSE DATALOGZ_BIOPS TO ROLE READ_USER_ROLE;
GRANT USAGE, OPERATE ON WAREHOUSE DATALOGZ_BIOPS TO ROLE WRITE_USER_ROLE;

GRANT USAGE ON DATABASE DATALOGZ_WH TO ROLE READ_USER_ROLE;
GRANT USAGE ON DATABASE DATALOGZ_WH TO ROLE WRITE_USER_ROLE;
GRANT ALL PRIVILEGES ON DATABASE DATALOGZ_WH TO ROLE DATALOGZ_DIAGNOSTICS_ADMIN_ROLE WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON DATABASE DATALOGZ_WH TO ROLE DATALOGZ_GATEWAY_ADMIN_ROLE WITH GRANT OPTION;

CREATE USER IF NOT EXISTS DATALOGZ_DIAGNOSTICS_ADMIN WITH PASSWORD = '<YOUR_SECURE_PASSWORD>' DEFAULT_ROLE = DATALOGZ_DIAGNOSTICS_ADMIN_ROLE;
CREATE USER IF NOT EXISTS DATALOGZ_GATEWAY_ADMIN WITH PASSWORD = '<YOUR_SECURE_PASSWORD>' DEFAULT_ROLE = DATALOGZ_GATEWAY_ADMIN_ROLE;

GRANT OWNERSHIP ON ROLE READ_USER_ROLE TO ROLE DATALOGZ_GATEWAY_ADMIN_ROLE REVOKE CURRENT GRANTS;
GRANT OWNERSHIP ON ROLE WRITE_USER_ROLE TO ROLE DATALOGZ_GATEWAY_ADMIN_ROLE REVOKE CURRENT GRANTS;

GRANT ROLE DATALOGZ_DIAGNOSTICS_ADMIN_ROLE TO USER DATALOGZ_DIAGNOSTICS_ADMIN;
GRANT ROLE DATALOGZ_GATEWAY_ADMIN_ROLE TO USER DATALOGZ_GATEWAY_ADMIN;

USE ROLE DATALOGZ_DIAGNOSTICS_ADMIN_ROLE;
USE DATABASE DATALOGZ_WH;
CREATE SCHEMA IF NOT EXISTS DATALOGZ_WH.POWERBI_INGEST;
CREATE SCHEMA IF NOT EXISTS DATALOGZ_WH.POWERBI_SOURCE;
CREATE SCHEMA IF NOT EXISTS DATALOGZ_WH.TABLEAU_INGEST;
CREATE SCHEMA IF NOT EXISTS DATALOGZ_WH.TABLEAU_SOURCE;
CREATE SCHEMA IF NOT EXISTS DATALOGZ_WH.BIOPS_GENERAL;

GRANT USAGE ON SCHEMA BIOPS_GENERAL TO ROLE READ_USER_ROLE;
GRANT USAGE ON SCHEMA BIOPS_GENERAL TO ROLE WRITE_USER_ROLE;

GRANT ALL PRIVILEGES ON SCHEMA POWERBI_INGEST TO ROLE DATALOGZ_DIAGNOSTICS_ADMIN_ROLE;
GRANT ALL PRIVILEGES ON SCHEMA POWERBI_SOURCE TO ROLE DATALOGZ_DIAGNOSTICS_ADMIN_ROLE;
GRANT ALL PRIVILEGES ON SCHEMA TABLEAU_INGEST TO ROLE DATALOGZ_DIAGNOSTICS_ADMIN_ROLE;
GRANT ALL PRIVILEGES ON SCHEMA TABLEAU_SOURCE TO ROLE DATALOGZ_DIAGNOSTICS_ADMIN_ROLE;
GRANT ALL PRIVILEGES ON SCHEMA BIOPS_GENERAL TO ROLE DATALOGZ_DIAGNOSTICS_ADMIN_ROLE;

GRANT SELECT, INSERT, UPDATE ON FUTURE TABLES IN SCHEMA POWERBI_INGEST TO ROLE DATALOGZ_DIAGNOSTICS_ADMIN_ROLE;
GRANT SELECT, INSERT, UPDATE ON FUTURE TABLES IN SCHEMA POWERBI_SOURCE TO ROLE DATALOGZ_DIAGNOSTICS_ADMIN_ROLE;
GRANT SELECT, INSERT, UPDATE ON FUTURE TABLES IN SCHEMA TABLEAU_INGEST TO ROLE DATALOGZ_DIAGNOSTICS_ADMIN_ROLE;
GRANT SELECT, INSERT, UPDATE ON FUTURE TABLES IN SCHEMA TABLEAU_SOURCE TO ROLE DATALOGZ_DIAGNOSTICS_ADMIN_ROLE;
GRANT SELECT, INSERT, UPDATE ON FUTURE TABLES IN SCHEMA BIOPS_GENERAL TO ROLE DATALOGZ_DIAGNOSTICS_ADMIN_ROLE;
GRANT SELECT, INSERT, UPDATE ON FUTURE TABLES IN SCHEMA BIOPS_GENERAL TO ROLE DATALOGZ_GATEWAY_ADMIN_ROLE;


CREATE OR REPLACE TABLE DATALOGZ_WH.BIOPS_GENERAL.ENTITLEMENT(
    account_id int,
    environment_id int,
    connector_id int,
    user_name varchar(256),
    system_name varchar(256),
    entitlement_type varchar(256),
    entitlement_status varchar(256),
    created_at timestamp default current_timestamp(),
    updated_at timestamp default current_timestamp()
);

GRANT INSERT, SELECT, UPDATE ON TABLE DATALOGZ_WH.BIOPS_GENERAL.ENTITLEMENT TO ROLE WRITE_USER_ROLE;

CREATE FILE FORMAT IF NOT EXISTS DATALOGZ_WH.json_file_format
    TYPE = 'json' STRIP_OUTER_ARRAY = true STRIP_NULL_VALUES = true;
    
USE ROLE ACCOUNTADMIN;
CREATE OR REPLACE STORAGE INTEGRATION datalogz_wh_prod_int; -- Add a name!
  TYPE = EXTERNAL_STAGE
  STORAGE_PROVIDER = 'S3'
  ENABLED = TRUE
  STORAGE_AWS_ROLE_ARN = '<your_IAM_role_ARN>'  -- Add your IAM role ARN here
  STORAGE_AWS_IAM_USER_ARN = '<your_IAM_user_ARN>' -- Add your IAM user ARN here if required
  STORAGE_ALLOWED_LOCATIONS = (  -- change 'powerbi' to 'tableau' or 'looker'
's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/groups/',
's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/groups_users/',
's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/groups_users_artifacts/',
's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/groups_users_subscriptions/',
's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/groups_unused/',
's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/scorecards/',
's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/scorecards_goals/',
's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/scorecards_goals_refresh_history/',
's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/scorecards_goals_status_rules/',
's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/scorecards_goals_values/',
's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/reports/',
's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/reports_users/',
's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/reports_pages/',
's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/reports_datasources/',
's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/reports_subscriptions/',
's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/dashboards/',
's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/dashboards_users/',
's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/dashboards_subscriptions/',
's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/dashboards_tiles/',
's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/datasets/',
's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/datasets_datasources/',
's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/datasets_users/',
's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/datasets_discover_gateways/',
's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/datasets_parameters/',
's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/datasets_direct_query_refresh_schedule/',
's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/datasets_extract_refresh_schedule/',
's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/datasets_push_dataset_tables/',
's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/datasets_refresh_history/',
's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/datasets_links_dataflows/',
's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/dataflows/',
's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/dataflows_users/',
's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/dataflows_datasources/',
's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/dataflows_export/',
's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/dataflows_links_dataflows/',
's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/groups_workspace_scan/',
's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/groups_workspace_scan_status/',
's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/groups_workspace_scan_result/',
's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/scan_results_datasets/',
's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/scan_results_datasets_tables/',
's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/scan_results_datasets_tables_columns/',
's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/scan_results_datasets_tables_measures/',
's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/scan_results_datasets_tables_sources/',
's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/xmla_sessions/',
's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/saved_issues/',
's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/users/',
's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/users_service_plans/',
's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/users_assigned_licenses/',
's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/capacities/',
's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/capacities_refreshables/',
's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/capacities_users/',
's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/capacities_workloads/',
's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/apps/',
's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/apps_users/',
's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/imports/',
's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/pipelines/',
's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/pipelines_users/',
's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/pipelines_stages/',
's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/pipelines_stages_artifacts/',
's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/pipelines_operations/',
's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/widely_shared_artifacts_links/',
's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/widely_shared_artifacts_published/',
's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/activities/',
's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/refreshables/',
's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/available_features/',
's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/dataflows_storage_accounts/',
's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/profiles/',
's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/gateways/',
's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/gateways_datasources/',
's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/gateways_datasources_users/',
's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/projects/',
's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/projects_workbooks/',
's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/projects_workbooks_connections/',
's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/projects_workbooks_extensions_analytics_connections/',
's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/projects_workbooks_preview_image/',
's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/projects_workbooks_revisions/',
's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/projects_workbooks_usage/',
's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/projects_workbooks_search_usage/',
's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/projects_workbooks_views/',
's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/projects_metrics/',
's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/projects_workbooks_scan_result/',
's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/scan_results_datasources/',
's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/scan_results_datasources_tables/',
's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/scan_results_datasources_tables_columns/',
's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/projects_sites_views/',
's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/projects_sites_views_search_usage/',
's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/projects_permissions/',
's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/projects_permissions_groups_capabilities/',
's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/datasources/',
's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/datasources_connections/',
's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/datasources_revisions/',
's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/metadata_datasources_certifications/',
's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/datasources_usage/',
's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/datasources_search_usage/',
's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/flows/',
's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/flows_runs/',
's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/flows_permissions/',
's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/flows_permissions_groups_capabilities/',
's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/flows_connections/',
's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/flows_usage/',
's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/flows_search_usage/',
's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/groups/',
's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/groups_users/',
's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/groups_users_favorites/',
's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/extensions_analytics_connections/',
's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/connected_apps/',
's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/custom_views/',
's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/data_alerts/',
's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/data_alerts_details/',
's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/schedules/',
's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/schedules_extracts/',
's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/metadata_tables/',
's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/metadata_tables_columns/',
's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/metadata_tables_permissions/',
's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/metadata_tables_certifications/',
's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/metadata_tables_search_usage/',
's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/metadata_databases/',
's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/metadata_databases_certifications/',
's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/metadata_databases_permissions/',
's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/jobs/',
's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/recommendations/',
's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/settings_mobile_security_settings/',
's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/settings_user_notifications/',
's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/sites_content_recently_viewed/',
's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/sites_embedding_settings/',
's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/subscriptions/',
's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/tasks_extract_refreshes/',
's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/tasks_linked/',
's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/tasks_run_flows/',
's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/virtual_connections/',
's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/metadata_virtual_connections_certifications/',
's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/saved_issues/'


);

  SHOW INTEGRATIONS;
  
  DESC STORAGE INTEGRATION datalogz_wh_prod_int;
  -- authorize the integration by navigating to the CONSENT_URL in your browser and logging in
  
  SELECT SYSTEM$GET_SNOWFLAKE_PLATFORM_INFO();  
  -- add network rules for each of the subnets displayed using the Azure CLI
  -- az storage account network-rule add --account-name <name_of_sa> --resource-group <name_of_rg> --subnet "<name_of_subnet>"
  -- then proceed below

GRANT CREATE STAGE ON SCHEMA POWERBI_INGEST TO ROLE DATALOGZ_DIAGNOSTICS_ADMIN_ROLE;
GRANT CREATE STAGE ON SCHEMA TABLEAU_INGEST TO ROLE DATALOGZ_DIAGNOSTICS_ADMIN_ROLE;
GRANT USAGE ON INTEGRATION datalogz_wh_prod_int TO ROLE DATALOGZ_DIAGNOSTICS_ADMIN_ROLE;

USE ROLE DATALOGZ_DIAGNOSTICS_ADMIN_ROLE; 
create or replace stage datalogz_wh.powerbi_ingest.powerbi_groups storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/groups/' file_format = json_file_format;
create or replace stage datalogz_wh.powerbi_ingest.powerbi_groups_users storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/groups_users/' file_format = json_file_format;
create or replace stage datalogz_wh.powerbi_ingest.powerbi_groups_users_artifacts storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/groups_users_artifacts/' file_format = json_file_format;
create or replace stage datalogz_wh.powerbi_ingest.powerbi_groups_users_subscriptions storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/groups_users_subscriptions/' file_format = json_file_format;
create or replace stage datalogz_wh.powerbi_ingest.powerbi_groups_unused storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/groups_unused/' file_format = json_file_format;
create or replace stage datalogz_wh.powerbi_ingest.powerbi_scorecards storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/scorecards/' file_format = json_file_format;
create or replace stage datalogz_wh.powerbi_ingest.powerbi_scorecards_goals storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/scorecards_goals/' file_format = json_file_format;
create or replace stage datalogz_wh.powerbi_ingest.powerbi_scorecards_goals_refresh_history storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/scorecards_goals_refresh_history/' file_format = json_file_format;
create or replace stage datalogz_wh.powerbi_ingest.powerbi_scorecards_goals_status_rules storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/scorecards_goals_status_rules/' file_format = json_file_format;
create or replace stage datalogz_wh.powerbi_ingest.powerbi_scorecards_goals_values storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/scorecards_goals_values/' file_format = json_file_format;
create or replace stage datalogz_wh.powerbi_ingest.powerbi_reports storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/reports/' file_format = json_file_format;
create or replace stage datalogz_wh.powerbi_ingest.powerbi_reports_users storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/reports_users/' file_format = json_file_format;
create or replace stage datalogz_wh.powerbi_ingest.powerbi_reports_pages storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/reports_pages/' file_format = json_file_format;
create or replace stage datalogz_wh.powerbi_ingest.powerbi_reports_datasources storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/reports_datasources/' file_format = json_file_format;
create or replace stage datalogz_wh.powerbi_ingest.powerbi_reports_subscriptions storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/reports_subscriptions/' file_format = json_file_format;
create or replace stage datalogz_wh.powerbi_ingest.powerbi_dashboards storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/dashboards/' file_format = json_file_format;
create or replace stage datalogz_wh.powerbi_ingest.powerbi_dashboards_users storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/dashboards_users/' file_format = json_file_format;
create or replace stage datalogz_wh.powerbi_ingest.powerbi_dashboards_subscriptions storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/dashboards_subscriptions/' file_format = json_file_format;
create or replace stage datalogz_wh.powerbi_ingest.powerbi_dashboards_tiles storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/dashboards_tiles/' file_format = json_file_format;
create or replace stage datalogz_wh.powerbi_ingest.powerbi_datasets storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/datasets/' file_format = json_file_format;
create or replace stage datalogz_wh.powerbi_ingest.powerbi_datasets_datasources storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/datasets_datasources/' file_format = json_file_format;
create or replace stage datalogz_wh.powerbi_ingest.powerbi_datasets_users storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/datasets_users/' file_format = json_file_format;
create or replace stage datalogz_wh.powerbi_ingest.powerbi_datasets_discover_gateways storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/datasets_discover_gateways/' file_format = json_file_format;
create or replace stage datalogz_wh.powerbi_ingest.powerbi_datasets_parameters storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/datasets_parameters/' file_format = json_file_format;
create or replace stage datalogz_wh.powerbi_ingest.powerbi_datasets_direct_query_refresh_schedule storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/datasets_direct_query_refresh_schedule/' file_format = json_file_format;
create or replace stage datalogz_wh.powerbi_ingest.powerbi_datasets_extract_refresh_schedule storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/datasets_extract_refresh_schedule/' file_format = json_file_format;
create or replace stage datalogz_wh.powerbi_ingest.powerbi_datasets_push_dataset_tables storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/datasets_push_dataset_tables/' file_format = json_file_format;
create or replace stage datalogz_wh.powerbi_ingest.powerbi_datasets_refresh_history storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/datasets_refresh_history/' file_format = json_file_format;
create or replace stage datalogz_wh.powerbi_ingest.powerbi_datasets_links_dataflows storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/datasets_links_dataflows/' file_format = json_file_format;
create or replace stage datalogz_wh.powerbi_ingest.powerbi_dataflows storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/dataflows/' file_format = json_file_format;
create or replace stage datalogz_wh.powerbi_ingest.powerbi_dataflows_users storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/dataflows_users/' file_format = json_file_format;
create or replace stage datalogz_wh.powerbi_ingest.powerbi_dataflows_datasources storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/dataflows_datasources/' file_format = json_file_format;
create or replace stage datalogz_wh.powerbi_ingest.powerbi_dataflows_export storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/dataflows_export/' file_format = json_file_format;
create or replace stage datalogz_wh.powerbi_ingest.powerbi_dataflows_links_dataflows storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/dataflows_links_dataflows/' file_format = json_file_format;
create or replace stage datalogz_wh.powerbi_ingest.powerbi_groups_workspace_scan storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/groups_workspace_scan/' file_format = json_file_format;
create or replace stage datalogz_wh.powerbi_ingest.powerbi_groups_workspace_scan_status storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/groups_workspace_scan_status/' file_format = json_file_format;
create or replace stage datalogz_wh.powerbi_ingest.powerbi_groups_workspace_scan_result storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/groups_workspace_scan_result/' file_format = json_file_format;
create or replace stage datalogz_wh.powerbi_ingest.powerbi_scan_results_datasets storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/scan_results_datasets/' file_format = json_file_format;
create or replace stage datalogz_wh.powerbi_ingest.powerbi_scan_results_datasets_tables storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/scan_results_datasets_tables/' file_format = json_file_format;
create or replace stage datalogz_wh.powerbi_ingest.powerbi_scan_results_datasets_tables_columns storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/scan_results_datasets_tables_columns/' file_format = json_file_format;
create or replace stage datalogz_wh.powerbi_ingest.powerbi_scan_results_datasets_tables_measures storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/scan_results_datasets_tables_measures/' file_format = json_file_format;
create or replace stage datalogz_wh.powerbi_ingest.powerbi_scan_results_datasets_tables_sources storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/scan_results_datasets_tables_sources/' file_format = json_file_format;
create or replace stage datalogz_wh.powerbi_ingest.powerbi_xmla_sessions storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/xmla_sessions/' file_format = json_file_format;
create or replace stage datalogz_wh.powerbi_ingest.powerbi_saved_issues storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/saved_issues/' file_format = json_file_format;
create or replace stage datalogz_wh.powerbi_ingest.powerbi_users storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/users/' file_format = json_file_format;
create or replace stage datalogz_wh.powerbi_ingest.powerbi_users_service_plans storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/users_service_plans/' file_format = json_file_format;
create or replace stage datalogz_wh.powerbi_ingest.powerbi_users_assigned_licenses storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/users_assigned_licenses/' file_format = json_file_format;
create or replace stage datalogz_wh.powerbi_ingest.powerbi_capacities storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/capacities/' file_format = json_file_format;
create or replace stage datalogz_wh.powerbi_ingest.powerbi_capacities_refreshables storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/capacities_refreshables/' file_format = json_file_format;
create or replace stage datalogz_wh.powerbi_ingest.powerbi_capacities_users storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/capacities_users/' file_format = json_file_format;
create or replace stage datalogz_wh.powerbi_ingest.powerbi_capacities_workloads storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/capacities_workloads/' file_format = json_file_format;
create or replace stage datalogz_wh.powerbi_ingest.powerbi_apps storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/apps/' file_format = json_file_format;
create or replace stage datalogz_wh.powerbi_ingest.powerbi_apps_users storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/apps_users/' file_format = json_file_format;
create or replace stage datalogz_wh.powerbi_ingest.powerbi_imports storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/imports/' file_format = json_file_format;
create or replace stage datalogz_wh.powerbi_ingest.powerbi_pipelines storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/pipelines/' file_format = json_file_format;
create or replace stage datalogz_wh.powerbi_ingest.powerbi_pipelines_users storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/pipelines_users/' file_format = json_file_format;
create or replace stage datalogz_wh.powerbi_ingest.powerbi_pipelines_stages storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/pipelines_stages/' file_format = json_file_format;
create or replace stage datalogz_wh.powerbi_ingest.powerbi_pipelines_stages_artifacts storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/pipelines_stages_artifacts/' file_format = json_file_format;
create or replace stage datalogz_wh.powerbi_ingest.powerbi_pipelines_operations storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/pipelines_operations/' file_format = json_file_format;
create or replace stage datalogz_wh.powerbi_ingest.powerbi_widely_shared_artifacts_links storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/widely_shared_artifacts_links/' file_format = json_file_format;
create or replace stage datalogz_wh.powerbi_ingest.powerbi_widely_shared_artifacts_published storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/widely_shared_artifacts_published/' file_format = json_file_format;
create or replace stage datalogz_wh.powerbi_ingest.powerbi_activities storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/activities/' file_format = json_file_format;
create or replace stage datalogz_wh.powerbi_ingest.powerbi_refreshables storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/refreshables/' file_format = json_file_format;
create or replace stage datalogz_wh.powerbi_ingest.powerbi_available_features storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/available_features/' file_format = json_file_format;
create or replace stage datalogz_wh.powerbi_ingest.powerbi_dataflows_storage_accounts storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/dataflows_storage_accounts/' file_format = json_file_format;
create or replace stage datalogz_wh.powerbi_ingest.powerbi_profiles storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/profiles/' file_format = json_file_format;
create or replace stage datalogz_wh.powerbi_ingest.powerbi_gateways storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/gateways/' file_format = json_file_format;
create or replace stage datalogz_wh.powerbi_ingest.powerbi_gateways_datasources storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/gateways_datasources/' file_format = json_file_format;
create or replace stage datalogz_wh.powerbi_ingest.powerbi_gateways_datasources_users storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/powerbi/admin/gateways_datasources_users/' file_format = json_file_format;
create or replace stage datalogz_wh.tableau_ingest.tableau_projects storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/projects/' file_format = json_file_format;
create or replace stage datalogz_wh.tableau_ingest.tableau_projects_workbooks storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/projects_workbooks/' file_format = json_file_format;
create or replace stage datalogz_wh.tableau_ingest.tableau_projects_workbooks_connections storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/projects_workbooks_connections/' file_format = json_file_format;
create or replace stage datalogz_wh.tableau_ingest.tableau_projects_workbooks_extensions_analytics_connections storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/projects_workbooks_extensions_analytics_connections/' file_format = json_file_format;
create or replace stage datalogz_wh.tableau_ingest.tableau_projects_workbooks_preview_image storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/projects_workbooks_preview_image/' file_format = json_file_format;
create or replace stage datalogz_wh.tableau_ingest.tableau_projects_workbooks_revisions storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/projects_workbooks_revisions/' file_format = json_file_format;
create or replace stage datalogz_wh.tableau_ingest.tableau_projects_workbooks_usage storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/projects_workbooks_usage/' file_format = json_file_format;
create or replace stage datalogz_wh.tableau_ingest.tableau_projects_workbooks_search_usage storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/projects_workbooks_search_usage/' file_format = json_file_format;
create or replace stage datalogz_wh.tableau_ingest.tableau_projects_workbooks_views storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/projects_workbooks_views/' file_format = json_file_format;
create or replace stage datalogz_wh.tableau_ingest.tableau_projects_metrics storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/projects_metrics/' file_format = json_file_format;
create or replace stage datalogz_wh.tableau_ingest.tableau_projects_workbooks_scan_result storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/projects_workbooks_scan_result/' file_format = json_file_format;
create or replace stage datalogz_wh.tableau_ingest.tableau_scan_results_datasources storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/scan_results_datasources/' file_format = json_file_format;
create or replace stage datalogz_wh.tableau_ingest.tableau_scan_results_datasources_tables storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/scan_results_datasources_tables/' file_format = json_file_format;
create or replace stage datalogz_wh.tableau_ingest.tableau_scan_results_datasources_tables_columns storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/scan_results_datasources_tables_columns/' file_format = json_file_format;
create or replace stage datalogz_wh.tableau_ingest.tableau_projects_sites_views storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/projects_sites_views/' file_format = json_file_format;
create or replace stage datalogz_wh.tableau_ingest.tableau_projects_sites_views_search_usage storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/projects_sites_views_search_usage/' file_format = json_file_format;
create or replace stage datalogz_wh.tableau_ingest.tableau_projects_permissions storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/projects_permissions/' file_format = json_file_format;
create or replace stage datalogz_wh.tableau_ingest.tableau_projects_permissions_groups_capabilities storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/projects_permissions_groups_capabilities/' file_format = json_file_format;
create or replace stage datalogz_wh.tableau_ingest.tableau_datasources storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/datasources/' file_format = json_file_format;
create or replace stage datalogz_wh.tableau_ingest.tableau_datasources_connections storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/datasources_connections/' file_format = json_file_format;
create or replace stage datalogz_wh.tableau_ingest.tableau_datasources_revisions storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/datasources_revisions/' file_format = json_file_format;
create or replace stage datalogz_wh.tableau_ingest.tableau_metadata_datasources_certifications storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/metadata_datasources_certifications/' file_format = json_file_format;
create or replace stage datalogz_wh.tableau_ingest.tableau_datasources_usage storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/datasources_usage/' file_format = json_file_format;
create or replace stage datalogz_wh.tableau_ingest.tableau_datasources_search_usage storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/datasources_search_usage/' file_format = json_file_format;
create or replace stage datalogz_wh.tableau_ingest.tableau_flows storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/flows/' file_format = json_file_format;
create or replace stage datalogz_wh.tableau_ingest.tableau_flows_runs storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/flows_runs/' file_format = json_file_format;
create or replace stage datalogz_wh.tableau_ingest.tableau_flows_permissions storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/flows_permissions/' file_format = json_file_format;
create or replace stage datalogz_wh.tableau_ingest.tableau_flows_permissions_groups_capabilities storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/flows_permissions_groups_capabilities/' file_format = json_file_format;
create or replace stage datalogz_wh.tableau_ingest.tableau_flows_connections storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/flows_connections/' file_format = json_file_format;
create or replace stage datalogz_wh.tableau_ingest.tableau_flows_usage storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/flows_usage/' file_format = json_file_format;
create or replace stage datalogz_wh.tableau_ingest.tableau_flows_search_usage storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/flows_search_usage/' file_format = json_file_format;
create or replace stage datalogz_wh.tableau_ingest.tableau_groups storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/groups/' file_format = json_file_format;
create or replace stage datalogz_wh.tableau_ingest.tableau_groups_users storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/groups_users/' file_format = json_file_format;
create or replace stage datalogz_wh.tableau_ingest.tableau_groups_users_favorites storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/groups_users_favorites/' file_format = json_file_format;
create or replace stage datalogz_wh.tableau_ingest.tableau_extensions_analytics_connections storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/extensions_analytics_connections/' file_format = json_file_format;
create or replace stage datalogz_wh.tableau_ingest.tableau_connected_apps storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/connected_apps/' file_format = json_file_format;
create or replace stage datalogz_wh.tableau_ingest.tableau_custom_views storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/custom_views/' file_format = json_file_format;
create or replace stage datalogz_wh.tableau_ingest.tableau_data_alerts storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/data_alerts/' file_format = json_file_format;
create or replace stage datalogz_wh.tableau_ingest.tableau_data_alerts_details storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/data_alerts_details/' file_format = json_file_format;
create or replace stage datalogz_wh.tableau_ingest.tableau_schedules storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/schedules/' file_format = json_file_format;
create or replace stage datalogz_wh.tableau_ingest.tableau_schedules_extracts storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/schedules_extracts/' file_format = json_file_format;
create or replace stage datalogz_wh.tableau_ingest.tableau_metadata_tables storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/metadata_tables/' file_format = json_file_format;
create or replace stage datalogz_wh.tableau_ingest.tableau_metadata_tables_columns storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/metadata_tables_columns/' file_format = json_file_format;
create or replace stage datalogz_wh.tableau_ingest.tableau_metadata_tables_permissions storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/metadata_tables_permissions/' file_format = json_file_format;
create or replace stage datalogz_wh.tableau_ingest.tableau_metadata_tables_certifications storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/metadata_tables_certifications/' file_format = json_file_format;
create or replace stage datalogz_wh.tableau_ingest.tableau_metadata_tables_search_usage storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/metadata_tables_search_usage/' file_format = json_file_format;
create or replace stage datalogz_wh.tableau_ingest.tableau_metadata_databases storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/metadata_databases/' file_format = json_file_format;
create or replace stage datalogz_wh.tableau_ingest.tableau_metadata_databases_certifications storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/metadata_databases_certifications/' file_format = json_file_format;
create or replace stage datalogz_wh.tableau_ingest.tableau_metadata_databases_permissions storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/metadata_databases_permissions/' file_format = json_file_format;
create or replace stage datalogz_wh.tableau_ingest.tableau_jobs storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/jobs/' file_format = json_file_format;
create or replace stage datalogz_wh.tableau_ingest.tableau_recommendations storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/recommendations/' file_format = json_file_format;
create or replace stage datalogz_wh.tableau_ingest.tableau_settings_mobile_security_settings storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/settings_mobile_security_settings/' file_format = json_file_format;
create or replace stage datalogz_wh.tableau_ingest.tableau_settings_user_notifications storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/settings_user_notifications/' file_format = json_file_format;
create or replace stage datalogz_wh.tableau_ingest.tableau_sites_content_recently_viewed storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/sites_content_recently_viewed/' file_format = json_file_format;
create or replace stage datalogz_wh.tableau_ingest.tableau_sites_embedding_settings storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/sites_embedding_settings/' file_format = json_file_format;
create or replace stage datalogz_wh.tableau_ingest.tableau_subscriptions storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/subscriptions/' file_format = json_file_format;
create or replace stage datalogz_wh.tableau_ingest.tableau_tasks_extract_refreshes storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/tasks_extract_refreshes/' file_format = json_file_format;
create or replace stage datalogz_wh.tableau_ingest.tableau_tasks_linked storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/tasks_linked/' file_format = json_file_format;
create or replace stage datalogz_wh.tableau_ingest.tableau_tasks_run_flows storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/tasks_run_flows/' file_format = json_file_format;
create or replace stage datalogz_wh.tableau_ingest.tableau_virtual_connections storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/virtual_connections/' file_format = json_file_format;
create or replace stage datalogz_wh.tableau_ingest.tableau_metadata_virtual_connections_certifications storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/metadata_virtual_connections_certifications/' file_format = json_file_format;
create or replace stage datalogz_wh.tableau_ingest.tableau_saved_issues storage_integration = datalogz_wh_prod_int url = 's3://<bucket_name>/datalogzbidiagnostics/data/tableau/admin/saved_issues/' file_format = json_file_format;
PreviousBuild NextPowerBI
Last updated 7 months ago