- 7561 Views
- 2 replies
- 4 kudos
Let's say I create a table like CREATE TABLE IF NOT EXISTS new_db.data_table (
key STRING,
value STRING,
last_updated_time TIMESTAMP
) USING DELTA LOCATION 's3://......';Now when I insert into this table I insert data which has say 20 columns a...
- 7561 Views
- 2 replies
- 4 kudos
Latest Reply
I tried running "REFRESH TABLE tablename;" but I still do not see the added columns in the data explorer columns, while I do see the added columns in the sample data
1 More Replies
- 1228 Views
- 1 replies
- 0 kudos
SELECT if((select count(*) from information_schema.table_privileges where grantee = 'samo@test.com' and table_schema='demo_schema' and table_catalog='demo_catalog')==1, (select count(*) from demo_catalog.demo_schema.demo_table), (select count(*) from...
- 1228 Views
- 1 replies
- 0 kudos
Latest Reply
Hi, GRANT and REVOKE are privileges on an securable object to a principal. And a principal is a user, service principal, or group known to the metastore. Principals can be granted privileges and may own securable objects.Also, you can use REVOKE ON S...
by
Ovi
• New Contributor III
- 3214 Views
- 4 replies
- 9 kudos
Hi all! I have an S3 bucket with Delta parquet files/folders with different schemas each. I need to create an RDD or DataFrame from all those Delta Tables that should contain the path, name and different schema of each.How could I do that?Thank you!P...
- 3214 Views
- 4 replies
- 9 kudos
Latest Reply
You can mount S3 bucket or read directly from it.access_key = dbutils.secrets.get(scope = "aws", key = "aws-access-key")
secret_key = dbutils.secrets.get(scope = "aws", key = "aws-secret-key")
sc._jsc.hadoopConfiguration().set("fs.s3a.access.key", ac...
3 More Replies
- 2642 Views
- 2 replies
- 5 kudos
We have multiple environments where the same tables are added so it's really hard to manually update the schema of the table across all the environments. We know that it's not ideal to update table schema a lot but our product is still evolving and s...
- 2642 Views
- 2 replies
- 5 kudos
by
Panna
• New Contributor II
- 1949 Views
- 1 replies
- 3 kudos
I'm creating an array which contains both string and double, just wondering if I can have multiple element type options for one array column? Thanks
- 1949 Views
- 1 replies
- 3 kudos
Latest Reply
Elements of any type that share a least common type can be used, https://docs.databricks.com/sql/language-manual/functions/array.html#arguments.Please correct me if I misunderstood to understand the requirement.
