Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

General Discussions

Discuss any topics that are not product-specific here.
SOLVED

Metadata loading in Hub

Matt_Curtis
9 - Comet

Hi there.  I'm experienced with Designer & Server. New to Hub and haven't used Connect.  I'm trying to load data from our Snowflake instance into my fresh/brand new Hub instance.  The Loader file is asking for Connect information, including a port and database and I'm not sure how to use it in Hub.  I'm trying to download and run the Loader App for Snowflake and I'm not sure what to put in the second screen. Thanks for any help you can provide.

 

Is there a Hub-version of this? 

Matt_Curtis_0-1607013446573.png

 

3 REPLIES 3
BryceL
Alteryx
Alteryx

Hi @Matt_Curtis ,

 

We use the same analytic app to load the metadata into Analytics Hub and provide a configuration in the Hub UI, so you don't have to run it through Designer. At a high level, you will need to create a data source, connection and credential for the Snowflake instance on your site (if it doesn't exist already) and then load metadata into the data catalog.

 

Additional info in the help docs: https://help.alteryx.com/current/alteryx-analytics-hub/data-sources-credentials-and-connections

Loading of data catalog is towards the bottom of that article under "Harvest Metadata to Build a Data Catalog".

 

Please let me know if you run into any issues.

 

Thanks!

Bryce

Matt_Curtis
9 - Comet

Hey @BryceL thanks for the response! I've gone through the documentation you linked to and created a data source, clicked "load metadata", then the job has failed.  Digging into the Loader Logs it looks like my account is insufficient since it's not an ACCOUNTADMIN.  Is that role required to run loader jobs?

 

Thanks!

mzegrodzki
Alteryx
Alteryx

Hi @Matt_Curtis

Within Snowflake loader that ROLE is required, in order to make sure that all the objects can be accessed and loaded (so permissions can be managed using AAH permissions model). 


Please try granting ACCOUNTADMIN role to a user being used within the process.

 

use role accountadmin;
use schema snowflake.account_usage;

 

More details can be found here: https://docs.snowflake.com/en/sql-reference/account-usage.html

 

Hope it helps. Thanks

Labels