03-14-2022 04:15 AM
Hello,
I want to create database (schema) and tables in my Databricks workspace using terraform.
I found this resources: databricks_schema
It requires databricks_catalog, which requires metastore_id.
However, I have databricks_workspace and I did not create any metastore and everything works fine. So how can I get metastore_id without creating a new mestastore, or how can I create databricks_schema (database) other way?
Best regards,
Łukasz
04-17-2022 10:41 AM
03-14-2022 05:45 AM
@Łukasz Jaremek , Strange with that id. For example from databricks cluster log you can get some info about metastore but not id... (maybe url can be used instead?)
example from log:
22/03/14 05:40:38 INFO MetastoreMonitor$: Internal internal metastore configured (config=DbMetastoreConfig{host=consolidated-westeurope-prod-metastore-addl-3.mysql.database.azure.com, port=3306, dbName=organization34353553, user=LoBp1K7HeU3FvyzM@consolidated-westeurope-prod-metastore-addl-3})
22/03/14 05:40:38 INFO DatabricksILoop$: Creating throwaway interpreter
22/03/14 05:40:38 INFO DataSourceFactory$: DataSource Jdbc URL: jdbc:mariadb://consolidated-westeurope-prod-metastore-addl-3.mysql.database.azure.com:3306/organization34353553?useSSL=true&sslMode=VERIFY_CA&disableSslHostnameVerification=true&trustServerCertificate=false&serverSslCert=/databricks/common/mysql-ssl-ca-cert.crt
04-17-2022 10:41 AM
04-28-2022 11:21 PM
Thank you for the answer.
Yes, that's probably it. I have to read about the UC.
Best regards,
Łukasz
04-27-2022 12:59 AM
Hi @Łukasz Jaremek , Just a friendly follow-up. Do you still need help, or @Hubert Dudek (Customer) and @Atanu Sarkar 's response help you to find the solution? Please let us know.
04-28-2022 11:24 PM
Hello @Kaniz Fatma , thank you for your interest.
I think @Atanu Sarkar solved my problem.
I'm sorry for the lack of response.
Best reagards,
Łukasz
04-29-2022 01:28 AM
Hi @Łukasz Jaremek , Thank you for the update. Appreciate your friendly response. Thank you for choosing the best answer for community.
Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you won’t want to miss the chance to attend and share knowledge.
If there isn’t a group near you, start one and help create a community that brings people together.
Request a New Group