VizQL Data Service from Tableau: Use Your Data, Your Way

By Dataprix on Wed, 08/14/2024 - 13:23

Discover Tableau’s VizQL Data Service, a new feature that allows users to make programmatic API requests for published data from Tableau.

The service enables you to request exactly the data you need, without being tied to any existing view or dashboard. This opens up a range of possibilities, from extracting a subset of columns to customizing data visualization for applications.

Key Benefits:
Programmatic access to Tableau data.
Ability to create custom experiences and workflows.
Filter, sort, and aggregate data on-demand.
This new service introduces a paradigm shift in Tableau, offering a controlled and precise way to provide data to users.

Detecting indexes, tables and packages not used on DB2

By Oscar_paredes on Mon, 02/10/2020 - 19:53

DB2, from version 9.7, allows to know easily what indexes are not being used in a Database. The query is also for tables and packages.

This is a useful tool for tuning indexes and detecting problems in their use.

After version 9.7 DB2 includes a new LASTUSED field in the SYSCAT.INDEXES, SYSCAT.TABLES and SYSCAT.PACKAGES tables.

This field indicates the date of last use of indexes, tables or packages.

For example, to query unused indexes since 1/1/2019, you could use this simple query:

TOP 10 rows on DB2

By Oscar_paredes on Sun, 12/15/2019 - 16:30

In this shosrt post we will show how to obtain the N first rows from a Query on IBM DB2.

With Oracle SQL would be with ROWNUM, and with SQL Server we'd use TOP.

 

This is the Top 10 query syntax:

select *

from My_Table

fetch first 10 rows only

 

 

Subscribe to SQL Query

Prueba Semrush gratis 14 días!