right(result_url, 6) AS slug_id

"BI_ANALYTICS"."SILVER"."SUBMISSIONS"

),

query_ids AS (

select

id AS dashboard_id,

slug_id,

latest_slug,

cells.value :formula :queryId::STRING AS query_id,

cells.value :formula :visId::STRING AS vis_id

from BI_ANALYTICS.VELOCITY_APP_PROD.DASHBOARDS d,

lateral flatten(input => published :cells) cells

where slug_id IN (select slug_id from all_db_slugs)

and published is not null

AND (query_id IS NOT NULL OR vis_id IS NOT NULL)

),

vis_query_ids AS (

"BI_ANALYTICS"."VELOCITY_APP_PROD"."VISUALIZATION_QUERIES"

WHERE visualization_id IN (select vis_id FROM query_ids)

group by query_id

),

all_query_ids AS (

SELECT 'y' AS for_bounty, query_id FROM query_ids GROUP BY query_id

UNION

SELECT 'y' AS for_bounty, query_id FROM vis_query_ids

),

all_query_data AS (

select

query_id, query_text, query_tag, warehouse_name