Hi team, by using python to create a data source, ...
# gooddata-platform
j
Hi team, by using python to create a data source, is there a attribute to define table prefix? It seems not on the sample code: https://www.gooddata.com/docs/cloud/connect-data/create-data-sources/snowflake/. Table prefix option is available on UI data source page.
i
Hi Jing, Firstly, could you kindly confirm which of our product are you working with, please? You are posting this in GD Platform channel, which is dedicated to our older product GoodData Platform, but the documentation that you are referring to belongs to our newer product GoodData Cloud. During the creation of Snowflake datasource, you only specify the schema. May I know why would you like to specify some table prefixes here?
j
@Ivana Gasparekova Our team is using the GoodData Platform with Snowflake as our data source, connected via password authentication. However, Snowflake will soon be disabling this authentication method. As a result, we are exploring alternative authentication options, which appear to be available only through the cloud.
We specify the table prefix because the LDM is published with tables that have the prefix defined in the data source. This feature is crucial for us, so we would like to know if it is supported with the new authentication option.
I believe ADD process also loaded data from the tables with prefix as well.
i
I see, thank you for the clarification. I assume that you are referring to this upcoming change: https://www.snowflake.com/en/blog/blocking-single-factor-password-authentification/ Please be aware that Snowflake is one of our partners and we always make sure that the integration with GoodData runs smoothly on both sides. Any required changes related to the authentication would be announced in advance from our end as well. I believe that you are speaking about the naming convention. The direct integration with cloud data warehouse works bit differently, actually: Create a Logical Data Model from Your Cloud Data Warehouse
Screen Shot 2024-12-09 at 11.29.03 AM.png
i
Thank you, now I understand that we are speaking about the Output stage. Not sure about the Python attribute for this, but I will ask around and let you know. You can surely generate the Output Stage via API, if needed: Generate the Output Stage for a Data Source based on the schema