Skip to main content

Advice and answers from the Openbridge Team

Search results for:Alteryx

Data Tools And Analytics FAQs
We suggest the use of best-in-class "transform" tools like Tableau Data Prep, Alteryx, or Trifacta, offering
Snowflake Data Lake + Azure Integration with Programmatic Access Token (PAT) Authentication
snowflake-warehouse-with-oauth-authentication -- If these IPs ever change, update the network rule: -- ALTER… ROLE_RESTRICTION = <YOUR_ROLE_NAME>; For example, if you used the default values from Step 2: ​ ALTER… ACCESS TOKEN openbridge_pat; USE ROLE <YOUR_ROLE_NAME>; ALTER USER <YOUR_USER_NAME> ADD PROGRAMMATIC
Snowflake Data Lake + GCS Integration with Program Access Token (PAT) Authentication
snowflake-warehouse-with-oauth-authentication -- If these IPs ever change, update the network rule: -- ALTER… POLICY IF NOT EXISTS openbridge_network_policy ALLOWED_NETWORK_RULE_LIST = ('openbridge_network_rule'); ALTER… ACCESS TOKEN openbridge_pat; ALTER USER <YOUR_USER_NAME> ADD PROGRAMMATIC ACCESS TOKEN openbridge_pat
Snowflake Troubleshooting Guide: Resolving "Invalid Grant" Errors
USER <service_account_name> SET DEFAULT_ROLE = '<correct_role>'; ALTER USER <service_account_name> SET… USER <username> SET RSA_USER_PUBLIC_KEY = '<public_key_value>'; Use ALTER Instead of DROP/CREATE… When modifying roles, prefer ALTER ROLE and incremental GRANT/REVOKE statements over dropping and
Snowflake Data Lake + S3 Integration with Programmatic Access Token (PAT) Authentication
snowflake-warehouse-with-oauth-authentication -- If these IPs ever change, update the network rule: -- ALTER… POLICY IF NOT EXISTS openbridge_network_policy ALLOWED_NETWORK_RULE_LIST = ('openbridge_network_rule'); ALTER… ACCESS TOKEN openbridge_pat; USE ROLE <YOUR_ROLE_NAME>; ALTER USER <YOUR_USER_NAME> ADD PROGRAMMATIC
Snowflake Warehouse with Programmatic Access Token (PAT) Authentication
snowflake-warehouse-with-oauth-authentication -- If these IPs ever change, update the network rule: -- ALTER… POLICY IF NOT EXISTS openbridge_network_policy ALLOWED_NETWORK_RULE_LIST = ('openbridge_network_rule'); ALTER… ACCESS TOKEN openbridge_pat; USE ROLE <YOUR_ROLE_NAME>; ALTER USER <YOUR_USER_NAME> ADD PROGRAMMATIC
Adding Snowflake User Permissions To Your OAuth App
ALTER USER "bob@apple.com" SET DEFAULT_ROLE = OPENBRIDGE3_ROLE; This makes Snowflake start Bob in the… full command set is: USE ROLE ACCOUNTADMIN; GRANT ROLE OPENBRIDGE3_ROLE TO USER "bob@apple.com"; ALTER… TO USER "bob@apple.com"; -- Make that role the user's default role for login / OAuth authorization ALTER
Configuring Your Amazon Redshift Data Warehouse Environment
created when you launched the cluster: grant create on database openbridge to {{username}}; To alter… default privileges, you can use the following query: ALTER DEFAULT PRIVILEGES IN SCHEMA {{schema}}… schema: grant all on schema openbridge to {{username}}; Lastly, see the default search path: ALTER
Amazon Sales & Traffic Reports Glossary
Does not reflect orders subsequently canceled or altered
Snowflake Data Lake + Azure Integration with Oauth Authentication
openbridge_ip_whitelist ALLOWED_IP_LIST = ('52.2.68.68/32', '52.54.227.22/32'); -- OR, modify your existing policy ALTER