Skip to content

Instantly share code, notes, and snippets.

@mifung
mifung / AZ Commands
Last active September 8, 2019 21:32
AZ Command
## AZ Command Key Vault
```
az keyvault secret list --vault-name "ContosoKeyVault"
```
@mifung
mifung / Analyzing Data in Azure Data Lake Storage Gen 2 using Databricks.md
Last active January 24, 2020 09:28
Analyzing Data in Azure Data Lake Storage Gen 2 using Databricks

Set up Data Lake Gen 2 in your Azure Subscription

  • Create a Storage Account
  • Select ‘BlobStorage’ for Account kind
  • Go to the Advanced tab and select ‘Data lake Storage Gen2’. Select ‘Enabled Hierarchical Namespace’

Create Storage Account

hierarchical

  • Once the storage is created, go to Azure Storage Explorer, it will appear in the Storage Account under your subscription.
@mifung
mifung / CICD with Data Factory.md
Last active January 24, 2020 09:29
CICD DataFactory

Azure DevOps CI/CD with Data Factory

Create a Data Factory pipeline in our Azure Portal

In this example, we have one simple copy activity.

  • Please note on the upper left hand corner, github is already set as the default repository
  • Currently, the branch is pointing at Master
  • Click the drop down on the New Branch or [Alt-N]
  • Enter a new feature Branch
  • Example "Thirdcopybranch Branch"
@mifung
mifung / Cosmos DB SQL queries.md
Last active August 19, 2024 21:16
Cheat Sheet for Cosmos DB SQL queries

Notes

  • Search text is case sensitive
  • Try to force attribute and text in your search to be in the same case
  • Wildcard search use STARTSWITH and ENDSWITH
  • two different types of nulls:
  • missing elements
  • actual null values.
  • Use IS_NULL()and IS_DEFINED() functions, to detect missing attributes and ternary logic
  • Cosmos DB SQL currently does not have an equivalent of SQL LEFT() function. Instead, use SUBSTRING()
  • There is no Year() function in Cosmos DB SQL, use SUBSTRING() to the date string and isolate