Skip to content

Instantly share code, notes, and snippets.

View emilefraser's full-sized avatar

Emile Fraser emilefraser

View GitHub Profile
@emilefraser
emilefraser / databricks-java.md
Created November 7, 2022 10:47
Databricks Java

intro to databricks java

@emilefraser
emilefraser / databricks-scala.md
Created November 7, 2022 10:46
Databricks Scala

intro to db scala

@emilefraser
emilefraser / databricks-python.md
Last active November 6, 2022 19:09
Databricks Python

Databricks Python code

@emilefraser
emilefraser / databricks-sql.md
Created November 6, 2022 19:07
Databricks SQL

Databricks related SQL code

@emilefraser
emilefraser / CreateTableFromFieldListIncludingTypes.sql
Last active July 18, 2019 06:43
[CreateTableFromFieldListIncludingTypes] Creating table from Field List Dynamically including type, scale and precision #table #create #dynamic
SELECT
-- Numeric DataTypes
CASE WHEN [f].[DataType] IN ('bigint', 'int', 'smallint', 'tinyint', 'bit', 'decimal', 'numeric', 'money', 'smallmoney', 'float', 'real')
THEN CASE WHEN [f].[DataType] IN ('decimal', 'numeric')
THEN '(' + CAST(f.[Precision] AS VARCHAR(5)) + ',' + CAST(f.[Scale] AS VARCHAR(5)) + ')'
WHEN [f].[DataType] IN ('float', 'real')
THEN ''
--THEN '(' + CAST(f.[Precision] AS VARCHAR(5)) + ')'
WHEN [f].[DataType] IN ('bigint', 'int', 'smallint', 'tinyint', 'bit', 'money', 'smallmoney')
THEN ''
@emilefraser
emilefraser / manifest.plist
Created March 24, 2018 01:49 — forked from hramos/manifest.plist
Sample manifest file for Over The Air iOS deployment
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE plist PUBLIC "-//Apple//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd">
<plist version="1.0">
<dict>
<key>items</key>
<array>
<dict>
<key>assets</key>
<array>
<dict>
@emilefraser
emilefraser / bash-online-conmmands.sh
Last active June 12, 2017 09:21
[Bash Synstax & Commands] #shell #bash #run
# Installl wget (only curl on new mac) with brew
brew install wget
# Downloading options
## wget
### wget [OPTION]... [URL]...
wget http://www-us.apache.org/dist/tomcat/tomcat-8/v8.5.9/bin/apache-tomcat-8.5.9.tar.gz
## curl
### curl [options] [URL...]
@emilefraser
emilefraser / github-code-extensions-colors.md
Created June 12, 2017 02:45
[Github Language Extensions & Colors] #github #maintain

Github's Classification of Language per File Extension (loose):

LanguageID LanguageName Extension Type Color
0 1C Enterprise 0 Programming #814CCC
0 1C Enterprise .bsl Programming #814CCC
0 1C Enterprise .os Programming #814CCC
1 ABAP .abap Programming #E8274B
2 AGS Script .ags Programming #B9D9FF
2 AGS Script .asc Programming #B9D9FF
@emilefraser
emilefraser / npm_scripts.sh
Last active June 12, 2017 02:39
[NPM Scripts] #installer #npm #run
#Installing Nodejs
echo "Installing Nodejs"
nvm install node
nvm use node
npm install -g coffee-script
npm install -g grunt-cli
npm install -g gulp
npm install -g bower