This topic describes how to connect Tableau to an Amazon Redshift database and set up the data source.
-
Click Connect to Data.
-
On the Connect page, click Amazon Redshift, and then do the following:
-
Type the name of the server that hosts the database and the name of the database you want to connect to.
-
Type the user name and password, and then click Connect.
Select the Require SSL check box when connecting to an SSL server.
If the connection is unsuccessful, verify that your user name and password are correct. If the connection continues to fail, your computer is having trouble locating the server. Contact your network administrator or database administrator.
-
Type the name of the server that hosts the database and the name of the database you want to connect to.
-
On the data source page, do the following:
-
(Optional) Click the default data source name at
the top of the page, and then type a unique data source name for use in
Tableau.
-
From the Schema drop-down list, select a schema.
-
Drag a table to the join area, and then click Go to Worksheet to start building the view. Alternatively,
drag additional tables to the join area and use conditions to join them. You can choose to combine tables or use Custom SQL when
you are working with multiple tables. You can also add joins later.
Optionally, you can make the following configurations before building the view:
-
Preview the data – In the preview area, select Update Now
to preview the first 10,000 rows of the data source. If you add tables,
remove tables, or make changes to the join conditions, click Update Now. If you want changes to automatically reflect in the preview area, click Automatically Update.
-
Change data types – Change the data type of a column by clicking the data type icon.
-
Rename or hide columns – Rename or hide a column by clicking the column header drop-down menu and selecting the respective option.
-
Connect live or use an extract –
At the top of the data source page, select a live or extract connection
to the data source. If you choose to take an extract, an Edit link
displays allowing you to set up filters that define a subset of the data
to include in the extract.
-
Add data source filters – Add data source filters to restrict the visibility and use of the fields in the data source.
-
Preview the data – In the preview area, select Update Now
to preview the first 10,000 rows of the data source. If you add tables,
remove tables, or make changes to the join conditions, click Update Now. If you want changes to automatically reflect in the preview area, click Automatically Update.
An example of an Amazon Redshift data source is shown below.
nice tutorials..thanks for sharing such a wonderful information.
ReplyDeleteTableau online training india
Really nice article.
ReplyDeleteAWS Training in Hyderabad
Best AWS Training in Hyderabad
AWS Online Training
AWS Training Online
AWS Training In Bangalore
Nice!
ReplyDeleteAWS Training in Hyderabad
Best AWS Training in Hyderabad
ReplyDeleteInteresting blog, here a lot of valuable information is available, it is very useful information.
RedShift Training
AWS RedShift Training
Amazon RedShift Online Training
This was an authentic and useful piece of information. Thank you for giving this useful content.
ReplyDeleteHow To Hack Emails
How To Hack an Email Account
Your writing is so powerful and inspiring. I feel so motivated after reading this.
ReplyDeleteEmbedded Linux Training In Hyderabad
Very nice I will try it…but could work with this is very good domain love it https://sclinbio.com/
ReplyDelete