Jun 20, 2021Optimize Bulk Import using Data Partition and Control Table in Azure Data Factory (ADF)Are you a Data Engineer/ETL Engineer? Have you dealt with loading billions of rows of data between two database systems? Used ADF to perform your ETL, EL, and ELT operations? Then this article is for you. We recently designed our Initial load ADF pipeline to load data from the On-Prem…Adf2 min read
Feb 20, 2021Tableau — Building a custom datasource catalogue using Webhooks and Metadata API.As we embedded the Tableau dashboards into our propitiatory SaaS product, which got 50+ workbook and darasources for each site(270+ sites in total)in a giant Tableau server, As part of our product offering we empower our customer’s data exploration skill by allowing them to customize our standard dashboard and extending…Tableau Consulting2 min read
Dec 3, 2020Tableau — Hyper API rescuer for complex RLS challengesHave you implemented the Row-Level-Security(RLS) in any of the Tableau Dashboard? Did you come-across complex scenario to update the user security columns on daily basis for an extract with millions of rows? Then this article is for you. Problem Statement We got an extract data source with incremental refresh enabled and RLS…Tableau2 min read
Oct 16, 2020Tableau - Cancel all jobs at single click!!Did you publish or manage Tableau server/online with multi-site setup? And having 10+ extracts running every day? Then this article is for you. With my current engagement, we got a giant Tableau server with 250+ sites and 50+ data sources each with extract enabled. We run the extract jobs daily…Tableau Consulting3 min read
Sep 28, 2020Tableau — Power of Server RepositoryAre you a big fan of building custom dashboards (using a custom query)? Do you want to know how Tableau maintains the relationship between objects in the portal? Though Tableau packed with a default set of dashboards, always business demands to develop custom dashboards. Thanks to Server Repository, which provides…Tableau Consulting6 min read
Jun 1, 2020Tableau — Refresh Extract programmatically using REST API.Thanks to Tableau REST API, this opens up many opportunities to automate the content management process in Tableau server. This article is a quick tip to harvest the benefit of REST API by performing full extract refresh of a published datasource by calling a set of endpoints. Sign-In into to…Tableau Server2 min read
May 11, 2020Tableau — Thanks to Metadata APIDo you deliver Tableau content with the multi-site environment? Did you came-across to perform impact analysis on Tableau content between Datasource and workbooks? Did you want to audit the usage of a specific data source field across all datasource? Then this article is for you. We got the below list…Tableau2 min read
May 4, 2020Tableau — Optimize Extract Refresh TimeWe applied below tricks which helped us to optimize the nightly extract refresh time, as we work extensively on the Tableau server-side like dashboard deployments, process automation, monitoring, and performance optimization. Hide all unused fields This makes a lot of sense, why we need to extract the data from source which is not at…Tableau Server2 min read
