Menu

▼

Redshift Query performance tuning

›
Redshift Query performance tuning tips Clustered vs Serverless Redshift: In a provisioned cluster, the resources allocated are predefined wh...

Incremental Load of Redshift data into Dynamodb table using AWS Glue

›
In today's post we will load incremental data from Redshift into Amazon Dynamodb using AWS Glue. To load data incrementally into Dynamod...

Power BI - Input box to filter the visuals

›
Scenario: In this scenario, we will add an Input box in the power bi dashboard that will filter the visuals.

AWS Redshift data sharing using Lake formation

›
Scenario:  In this scenario, we will be configuring data sharing between two Redshift databases in different accounts via central access man...

Informatica EDC profiling 10.4.1 Error - Could not create id creator for schema dbo and table due to missing row count result summary

›
Scenario: We want to integrate Azure SQL with Informatica EDC 10.4.1 and run profiling.  Error: Integration and connection test was succes...
4 comments:

Tableau - Create Box plot visual to display the CAGR

›
Today, we will learn on how to create and compare historical vs future CAGR using a box plot chart

Export Athena View as CSV to AWS S3 using Glue

›
Today we will learn on how to export Athena view to AWS S3 using Glue

Move file from one S3 folder to another using AWS Glue

›
Today we will learn on how to move file from one S3 location to another using AWS Glue 
3 comments:

Create a parameter to filter the visual in Tableau Dashboard

›
Today we will learn on how to Create a parameter to filter the visual in Tableau                                                      

AWS Glue - Unpivot columns into rows using python shell job

›
Today we will learn on how to unpivot columns into rows using AWS Glue python shell job
1 comment:

Create multiple dropdown list filters in a tableau dashboard to filter multiple sheets

›
Today we will learn on how to create multiple filters (as parameters) in a tableau dashboard to filter multiple sheets

Import data to Azure Cosmos DB using Azure DocumentDB Data Migration Tool

›
Today we will learn how to import data from our SQL Server database to Cosmos DB on Azure. We will use "AdventureWorks2016"...

Tableau - Change bar chart colours

›
Today we will learn on how to change the color of each bar in the bar chart visual in Tableau
1 comment:

Tableau visual error - field does not exist in the table

›
Error: The field <fieldname> does not exist in the table Reason:  Once you refresh the tableau data source, there is a possibility (i...

How to resolve Configuration Package template Decimal Error in Business Central

›
Problem Statement: Customer is getting Decimal error while importing data through the Configuration package template.   Resolution:  The er...

Get Started with Azure Cosmos db - SQL API

›
Azure Cosmos DB Introduction An Azure Cosmos DB is a document-oriented and a non-relational database. It does not model data in...

Create a view in AWS Athena by merging two SQL queries using Union All

›
Today we will lean on how to create a view in AWS Athena by merging multiple queries result in one query To merge multiple queries in Athen...
1 comment:

Setup Billing Alerts for AWS Services using CloudWatch

›
Today we will learn on how to setup billing alerts for AWS Services AWS Cloud Watch service is used to create billing alarms for all the A...