Every since using 0.46 (currently 0.46.6.4) I and a lot of others run into
a. permissions issues always somehow related to sql questions (some not all) where the query is in a place where a user should be able to access it.
You do not have permissions to run this query.
b. Array mapping issues with error messages like this:
Input to substitute-native-parameters__101938 does not match schema: e[0;33m [nil (named {:query (not (instance? java.lang.String a-clojure.lang.PersistentArrayMap))} arg1)] e[0m
These questions work until you reference it with the GUI as a base question.
EXAMPLE QUERY THAT PRODUCES THIS ERROR:
with who_used_what as
(
SELECT
`datamart.log_big_query`.`operation_id` AS `id`,
`datamart.log_big_query`.`metabase_user_id` AS `metabase_user_id`,
a.Name,
`datamart.log_big_query`.`timestamp` AS `timestamp`,
`datamart.log_big_query`.`job_type` AS `job_type`,
`datamart.log_big_query`.`create_time` AS `create_time`,
`datamart.log_big_query`.`start_time` AS `start_time`,
`datamart.log_big_query`.`end_time` AS `end_time`,
`datamart.log_big_query`.`total_slot_ms` AS `total_slot_ms`,
`datamart.log_big_query`.`billing_tier` AS `billing_tier`,
`datamart.log_big_query`.`output_row_count` AS `output_row_count`,
`datamart.log_big_query`.`referenced_tables` AS `referenced_tables`,
`datamart.log_big_query`.`total_billed_bytes` AS `total_billed_bytes`,
`datamart.log_big_query`.`total_processed_bytes` AS `total_processed_bytes`,
`datamart.log_big_query`.`job_state` AS `job_state`,
`datamart.log_big_query`.`dt` AS `dt`,
table_array as table_used
FROM `datamart.log_big_query`, UNNEST(`datamart.log_big_query`.`referenced_tables`) AS table_array
left join {{#508-user-mapping}} a on a.id=`datamart.log_big_query`.`metabase_user_id`
WHERE (`datamart.log_big_query`.`dt` >= date_trunc(date_add(current_date(), INTERVAL -30 day), day))
)
select
id,
row_number() over (partition by id) as table_rank_within_id,
Name,
REGEXP_REPLACE(REGEXP_EXTRACT(table_used, r'datasets/(.*)'), r'tables/', '') as table_used,
dt
from who_used_what
order by id
This makes the SQL questions almost useless at the moment and we are losing time a lot since then. Are there tickets already describing these issues that I can follow?