View FlowerSVGPath.txt
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
M0 -0.97Q 0.62 -0.76 0 0.08Q 0.62 -0.76 1 -0.24Q 0.67 0.3 0 0.08Q 0.67 0.3 0.62 0.93Q 0 0.79 0 0.08Q 0 0.79 -0.62 0.93Q -1 0.3 0 0.08Q -1 0.3 -1 -0.24Q -0.62 -0.76 0 0.08Q -0.62 -0.76 0 -0.97Q 0.62 -0.76 0 0.08z |
View Comet.json
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
{ | |
"data": {"name": "dataset"}, | |
"title": "Change In Percent of Americans Living Alone - 1980 vs 2018", | |
"height": 40, | |
"width": 350, | |
"mark": {"type": "trail"}, | |
"encoding": { | |
"facet": { | |
"field": "Entity", | |
"title": null, |
View StreamGraphDeneb.json
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
{ | |
"data": {"name": "dataset"}, | |
"mark": "area", | |
"encoding": { | |
"x": { | |
"timeUnit": "weekyear", | |
"field": "Date", | |
"title": null, | |
"axis": {"domain": false, "format": "%b %Y", "tickSize": 0} | |
}, |
View Color 1.M
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
let | |
//Get values 0 - 255 | |
Source = Values, | |
//Call that column R for Red | |
#"R Dec" = Table.RenameColumns(Source,{{"Column1", "R Dec"}}), | |
//Crossjoin to Values to get Green values 0 - 255 | |
#"G Dec" = Table.AddColumn(#"R Dec", "Custom", each Values), | |
#"Expanded G Dec" = Table.ExpandTableColumn(#"G Dec", "Custom", {"Column1"}, {"G Dec"}), | |
//Crossjoin to Values to get Blue values 0 - 255 | |
#"B Dec" = Table.AddColumn(#"Expanded G Dec", "B", each Values), |
View SQLDWTableSwapWithClassifications
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
CREATE PROC SwapWithMetadata | |
@SrcSchema NVARCHAR(128), | |
@SrcTable NVARCHAR(128), | |
@DestSchema NVARCHAR(128), | |
@DestTable NVARCHAR(128), | |
@TransferMetadata BIT, | |
@DropOldTable BIT | |
AS | |
BEGIN |
View TF Dynamics CRM Source Biml
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<!-- This goes in your data flow as the source --> | |
<CustomComponent Name="TF Dynamics 365 <#=table.Name#>" ComponentTypeName="PragmaticWorks.TaskFactory.DynamicsSource" Version="1" ContactInfo="Dynamics Source;Pragmatic Works, Inc; Task Factory (c) 2009 - 2016 Pragmatic Works, Inc; http://www.pragmaticworks.com;support@pragmaticworks.com" UsesDispositions="true"> | |
<Annotations> | |
<Annotation AnnotationType="Description">Extract data from Microsoft Dynamics CRM.</Annotation> | |
</Annotations> | |
<DataflowOverrides> | |
<OutputPath OutputPathName="Dynamics Source Output"> | |
<!-- Iterate through the columns (I'm passing in table and column from another file), ignoring any audit columns you may have added to your table. Set the Error Row Disposition and Truncation Row Disposition. --> | |
<# foreach (var column in table.Columns.Where(c => !c.Name.Equals("AuditETLLogID") && !c.Name.Equals("AuditIn |
View PL_Copy_MySourceDBToADLS.biml
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<#@ import namespace="System.Data" #> | |
<#@ import namespace="System.Text" #> | |
<#@ property name="targetTables" type="DataView"#> | |
<#@ property name="frequency" type="string"#> | |
<#@ property name="scope" type="string"#> | |
{ | |
"$schema": "http://datafactories.schema.management.azure.com/schemas/2015-09-01/Microsoft.DataFactory.Pipeline.json", | |
"name": "PL_Copy_MySourceDBToADLS_<#=frequency#>_<#=scope#>", | |
"properties": { | |
"description": "<#=frequency#> <#=scope#> copies of data from Source db to the data lake.", |
View Biml ADF Dataset Generation Snippet.txt
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<#@ template tier="10" #> | |
<#@ import namespace="System.Data" #> | |
<#@ import namespace="System.Text" #> | |
<#@ code file="BGHelper.cs" #> | |
<#@ import namespace="BGHelper" #> | |
<Biml xmlns="http://schemas.varigence.com/biml.xsd"> | |
</Biml> | |
<# | |
string mdFilePath = "C:\\Users\\admin\\Source\\Workspaces\\SH Data Warehouse\\metadata"; |
View 1_DS_OnPremSQL_MySourceDB_Schema_Table.biml
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<#@ property name="schema" type="string" #> | |
<#@ property name="table" type="string" #> | |
<#@ property name="frequency" type = "string" #> | |
{ | |
"$schema": "http://datafactories.schema.management.azure.com/schemas/2015-09-01/Microsoft.DataFactory.Table.json", | |
"name": "DS_OnPremSQL_MySourceDB_<#=schema#>_<#=table#>", | |
"properties": { | |
"type": "SqlServerTable", | |
"linkedServiceName": "LS_OnPremSQL_MySourceDB", |
View TabularModelDMVsForDocumentation
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
//list available DMVs | |
Select * from $SYSTEM.DBSCHEMA_TABLES where table_type = 'Schema' order by table_name | |
//Useful DMVs for 2016 SSAS Tabular Models | |
Select * from $SYSTEM.TMSCHEMA_ATTRIBUTE_HIERARCHY_STORAGES //distinct data count for each column | |
Select * from $SYSTEM.TMSCHEMA_ATTRIBUTE_HIERARCHIES //ties hierarchy id to column | |
SELECT * from $SYSTEM.TMSCHEMA_COLUMN_STORAGES //has order by column, row count is inaccurate | |
Select * from $SYSTEM.TMSCHEMA_COLUMNS //column name, ID for table, data type, category, hidden, iskey, isunique, is nullable, summarize by, expression for calc columns, hierarchy id, refresh time, modify time. source provider type, display folder | |
SELECT * from $SYSTEM.TMSCHEMA_DATA_SOURCES //connection string, account, impersonation mode, name | |
Select * from $SYSTEM.TMSCHEMA_HIERARCHIES //hierarchy name, display folder |
NewerOlder