Learning BI

  You need to have a Snowflake Data platform for it . If not please create one as below: You can start by signing up for a free trial on Snowflake: Sign up for a free trial by following link https://signup.snowflake.com/ and completing the sign-up form. Select the Enterprise edition, choose a cloud provider and region, and agree to the terms of service. Click GET STARTED. After submitting the sign-up form, you should receive an email asking you to activate your account. Click the link in the email and a new tab will open up where you’ll create your username and password. Complete the form and click Get started. Congrats! Your workspace is ready for some data.  Now to load sample data use below queries. #creating Warehouse, Database and schemas create warehouse transforming; create database raw; create database analytics; create schema raw.jaffle_shop; create schema raw.stripe; #creating customer table and loading Data create table raw.jaffle_shop.customers  ( id integer, ...

               Most of the Companies adhere to password policy of 60-90 days . Tableau workbooks, Datasources and Flows needs to have the DB password updated adhering to the policy.               I want to make an executable that makes easy to change the passwords. Here is the new Executable that helps to change the passwords in tableau objects. import tableauserverclient as TSC import argparse ,os, configparser, re from argparse import ArgumentParser, ArgumentDefaultsHelpFormatter import logging import datetime CONFIGURATION_FILE="passwordconfig.txt" #configuration file name and path.  #Copy the config file from the below  #logmodule def create_logger(log_id):     logger = logging.getLogger(log_id)     logger.setLevel(logging.DEBUG)     fh = logging.FileHandler(filename="passwordchangelog.txt") #log filename and its path     fh.setLevel(logging.DEB...

  To Enable Einstein Discovery on Tableau Server  We need to enable Extension on Tableau Server . There are few Prerequisites and requirements to enable it. The whole process is described below.  CORS A prerequisite for this is configuring CORS in Salesforce Org. Here is the process to enable CORS Sign in to your Salesforce.com developer account, click your user name in the upper-right, and then select Setup . In the left navigation column, search for "cors" and select CORS . In CORS , in the Allowed Origins List section, click New . In CORS Allowed Origin List Edit , enter the URL of your Tableau server, beginning with "https://". For more information about the URL pattern, see the Salesforce developer documentation: https://developer.salesforce.com/docs/atlas.en-us.chatterapi.meta/chatterapi/extend_code_cors.htm Click Save . Reference : https://help.tableau.com/current/server/en-us/config_cors_sfdc.htm OAUTH If you are integrating Einstein Discovery extensions w...