Skip to content

Instantly share code, notes, and snippets.

@mattm

mattm/lines.sql Secret

Created November 12, 2018 17:23
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save mattm/cd65f0120dc18cc58518f0b1323b3567 to your computer and use it in GitHub Desktop.
Save mattm/cd65f0120dc18cc58518f0b1323b3567 to your computer and use it in GitHub Desktop.
Download ZIP
Single vs multiple lines
Raw
lines.sql
# Good: Multiple columns per line
...
SELECT email, created_at AS expressed_interest_at
FROM helpscout.conversation c
...
# Good: One column per line
...
SELECT
email,
FROM_UNIXTIME(property_beacon_interest/1000) as expressed_interest_at
FROM
hubspot.contact
...
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment