Tableau and Custom SQL - plus stored procedure, parameters and initial SQL | sqlbelle

In this video we will walk through:
- using Custom SQL in Tableau
- how to use Parameters with Custom SQL
- how to use stored procedures
- how Custom SQL is different from Initial SQL

The demo uses SQL Server, but the topics are applicable to other RDBMSs (MySQL, PostgreSQL, etc)

Let's connect:

Chapters
0:26 - Setup
2:59 - Custom SQL
3:55 - Custom SQL with Parameters
5:29 - Stored Procedure
9:04 - Custom SQL vs Initial SQL

Additional Tutorials

Level Up Tableau

Table Calculations

Level of Detail (LOD) Expressions

Calculations Playlist

Sets and Set Actions

Top 1-5 LOD Expressions

Dates

Filters

Sample Certification Exam Questions

[equiwave]

This was a timely video as I was just going through how to make use of Custom SQL and Initial SQL in Tableau. Thanks for this video Donabel!!!👍💯

[savvyf.]

OMG thank you so so much. I just had a business user ask about turning their live connection to an extract with stored procedures and this is exactly what I was looking for! Thank you thank you

[RazaKhan-meds]

Best Video, Explanation is very easy to understand. Thanks

[timbeard]

Perfect! Looks like this could fix an issue I have with a client. Super video. Just the right length and depth - thank you!

[vijaykesarkar]

Great explanation, thank you for this video.

[piyushk]

Really I appreciate your way of explanations ...I learnt alot from you....Thanx a ton

[poonamwaghmare]

Thank you very much Donabel for this wonderful Video.😍🥰❤

[DaddyYow]

wow it's awesome, however, I got this error when I tried to connect my store proc "Unable to complete action
The "[dbo].[Data_Weekly]" stored procedure returned no results. The fields don't have column names, or the data in the fields is not a supported data type.
Unable to connect to the Microsoft SQL Server server "Server1". Check that the server is running and that you have access privileges to the requested database."

[MrBasu-iqmd]

I feel the use of stored procedures is very limited in Tableau. How do you use a stored procedure in Tableau that creates a temp table inside the procedure and then returns a select statement from the that temp table??
Is it even possible in Tableau??

[sandrahu]

exactly what i am looking for lately. You always deliver what we expected. Thanks again. I gave you tumble up each video i watched.

[timbeard]

Hi Donabel, I'm using quite complex SQL queries and finding that queries that work in Oracle SQL Developer fail in Tableau Custom SQL, generating various generic and unspecific errors. Other than Tableau not liking a semicolon at the end of a query, do you have any other tips or a syntax comparison?

[guanyilu]

Hello, really lover your tutorials, it is very helpful. Just wondering do you have any schedule for live session? Absolutely need to join !

[ericgoodmandzacka]

This awesome. I love the fact that you have created a database for Superstore data. Can you share the database script with us. Thank you. You are amazing!!!

[achusridhar]

Hi Mam, can you put a video on how to make an extract connection with stored proc that are using paramaters for From and To dates.

[naveennaravala]

Custom SQL or Stored Procedure which is best for performance ?

[firstname]

it seems like passing the product name to the sql could lead to a sql injection attack