Major issues with sql questions since 0.46

1

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?

2

Problem b has been fixed in 46.7. Problem a) we need to get the repro steps

1 Like