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:
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.
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;