Stack Overflow
Stack Overflow

Questions tagged [sql-data-warehouse]

108 questions
0
votes
1 answer

Transfer Tables from One Azure Datawarehouse to Another of Different Subscription

I want to transfer some tables from one azure datawarehouse to another azure data warehouse. But main problem is that both are under different azure subscription. Could anyone told me the source and target both are having different subscription in…
Puneet Khandelwal
  • 1
  • 1
0
votes
1 answer

How do I combine multiple tables? (First has data from this month, second has all other previous data)

I am looking to create a query that shows shipping number, the container ID, the tracking number, the location it was last moved to, what time it was moved, and who moved it. Here's the issue. We recently backed up or transaction history onto…
Gary Goldsmith
  • 13
  • 2
0
votes
1 answer

Not able to get the dbname, rolename, userid, last access date, read/write access for a Snowflake target table

As a part of auditing in my project and I need to find the db name, user name, last access date, read/write access, role name for the tables present in the Snowflake target. Can someone please help me with this?
Manan joshi
  • 1
  • 2
0
votes
2 answers

force replication of replicated tables

Some of my tables are of type REPLICATE. I would these tables to be actually replicated (not pending) before I start querying my data. This will help me avoid data movement. I have a script, which I found online, which runs in a loop and do a SELECT…
Henrik F
  • 1
  • 1
0
votes
0 answers

Snowflake schema causing multiple rows

I'm creating a data warehouse and we have company -> Sectors -> Org I have created three dimension Table Company CompanyKey Company ID CompanyName 1 1.1 ABC 2 2.1 XYZ …
XOXO
  • 1
  • 3
0
votes
2 answers

Employee Dimension Truncated everyday in Datawarehouse

I am developing a new data warehouse and my source tables for the employee dimension gets truncated every day and reloaded with all history and updates,deletes and new inserts. The columns which tracks these changes are effective date & effective…
XOXO
  • 1
  • 3
0
votes
0 answers

Need a query to join 2 columns of the same table with max(column_name) condition

[![enter image description here][1]][1] SELECT POLICY_NO, FORMATTED_POLICY_NUMBER, POLICY_EFFECTIVE_DATE AS Effectivedt, POLICY_REWRITTEN_FROM Frompolicy, POLICY_EXPIRATION_DATE FromExpirationDate FROM…
Sam
  • 103
  • 1
  • 1
  • 10
0
votes
1 answer

How to preserve Referential Integrity when initializing Key FACT\DIM tables

Where I work we initialize ("INIT" => truncate & load) a Fact\ Dimension table on the rare occasions when the need arise. Such "INIT" requires all object referencing the initialized object to be initialized subsequently in order to preserve RI…
Expialidoshes
  • 26
  • 4
0
votes
1 answer

Revenue Measure in Datawarehouse

I am building a Data warehouse for finance team and we have measure revenue, expense , revenue - expense = gross margin They are connect to following dimension Project, Org, Client, Date However some of the Project id which are present in Revenue…
user6167232
  • 13
  • 9
0
votes
1 answer

Single Record Dimensions in SQL Data Warehouse, seems improper, how else can I provide for these needs?

The business has a need for some single value dimensions: DIM_BuildDate - store datetime of the DW build, with latest inventory date DIM_CurrentAccountingPeriod - what is the accounting period now (at build date) DIM_CurrentExchangeRate - what is…
Chris Adragna
  • 625
  • 8
  • 18
0
votes
1 answer

Fact table design in Azure SQL Data Warehouse

Which is the best index and distribution design for relatively small fact tables (on average 30 million rows per table). The structure of each table is similar to the following: CREATE TABLE FactTable (     TimeDimensionID INT NOT…
Diego Carrillo
  • 9
  • 4
0
votes
2 answers

Is it possible to alter columns by matching them to another temporary table that exist?

I am working on masking personal data in several databases in SQL Datawarehouse. I have created a table with columns that i want to be masked and would like to alter these columns that exists in several tables in a database by a single script like…
Robi Morro
  • 3
  • 2
0
votes
0 answers

Which Distribution Method to be used to move Redshift Data to Azure SQL Data warehouse

I have a table in Redshift having datatype as text. I want to move this Data to Azure Data Warehouse. Can anyone suggest what could be the best distribution method(Hash or Round Robin) for this? as the data type is text in Redshift and has big data…
Pooja
  • 71
  • 1
  • 9
0
votes
2 answers

SQL Server fill in Empty Rows

Good Afternoon, I had an interesting question that I wanted to put the the stack overflow community. We have a data set in our data warehouse (SQL Server) with unique identifier and several months for that unique identifier. For example if one…
George Eivaz
  • 145
  • 2
  • 10
0
votes
1 answer

How to design Dimension and Fact table in Azure Data Warehouse?

I am working on migrating the SQL Server Databases to Azure Data Warehouse. I had dimension tables in earlier DB which had dim ids (basically integer values) and those were referred in fact tables for easy data fetch. These dim ids were generated…
Pratik Somaiya
  • 695
  • 5
  • 18
1 2 3 4 5
6
7 8