Hello guys!I have the following case:It has been decided that the json file will be read from a following definition ( from volume) , which more or less looks like this: CREATE OR REPLACE VIEW [catalog_name].[schema_name].v_[object_name]
AS
SELECT r...
Hello Briksters, i am looking for a giving a grand to developer being able execute with SHOW GROUPS WITH USER '***@***' without admin permission on UC.Could you give any tips to do it? UC Admin is able to see result query, but developer is not.
Thank you for response.But there no issue with NULL value when I query view created on my cluster which has set the flagspark.sql.legacy.json.allowEmptyString.enabled = TrueWithout that flag on session or cluster I get NULL value querying json.The is...
Thank you for your comprehensive answer.I assume from what you have written that this cannot be done without admin permissions on the metastore.So is there any other way to check who is in which group?
I hope it helps:SELECT DATEADD(DAY, rnk - 1, '{{StartDate}}')
FROM (
WITH lv0(c) AS(
SELECT 1 as c
UNION ALL
SELECT 1
)
, lv1 AS (
Select t1.c
from lv0 t1
cross JOIN lv0 t2
)
, lv2 AS (
Select t1....
