Setting up your external test data from a CSV file
+Create new data source
.
CSV based
from the dropdown and select the CSV file containing your data.
save
at the bottom of the page.
save
at the bottom of the page.all
, and
, any
, array
, as
, at
, between
, both
, by
, call
, case
, cast
, check
, coalesce
, constraint
, convert
, corresponding
, create
, cross
, cube
, default
, distinct
, do
, drop
, else
, every
, except
, exists
, fetch
, for
, foreign
, from
, full
, grant
, group
, grouping
, having
, in
, inner
, intersect
, into
, is
, join
, leading
, left
, like
, natural
, not
, nullif
, on
, or
, order
, outer
, primary
, references
, right
, rollup
, select
, set
, some
, sum
, table
, then
, to
, trailing
, trigger
, union
, unique
, using
, values
, when
, where
, with
STRING
, however you can pick any of the following types:
Data source type |
---|
BOOLEAN |
DECIMAL |
INTEGER |
STRING |
DATE |
TIME (time zoned) |
TIME (not time zoned) |
DATETIME (time zoned) |
DATETIME (not time zoned) |
username (STRING) | age (INTEGER) | first_name (STRING) | height (DECIMAL) | email (STRING) | dob (DATETIME, time zoned) | premium (BOOLEAN) |
---|---|---|---|---|---|---|
admin | 64 | Bob | 1.8 | bob@example.com | 1962-12-31T16:50:31+05:00 | true |
bill | 27 | Bill | 1.92 | bill@example.com | 1997-05-24T19:18:12Z | false |
jill | 15 | Jill | 1.70 | jill@example.com | 2009-11-07T04:34:01+01:00[Europe/Paris] | false |
jane | 74 | Jane | 1.81 | jane@example.com | 1952-01-13T10:10:10-12:00 | true |
DATE
, TIME
and DATETIME
types, you can specify your own format string using the elements in the following table:
Letter | Date or Time Component | Presentation | Examples |
---|---|---|---|
G | Era designator | Text | AD |
y | Year | Year | 1996; 96 |
Y | Week year | Year | 2009; 09 |
M | Month in year | Month | July; Jul; 07 |
w | Week in year | Number | 27 |
W | Week in month | Number | 2 |
D | Day in year | Number | 189 |
d | Day in month | Number | 10 |
F | Day of week in month | Number | 2 |
E | Day name in week | Text | Tuesday; Tue |
u | Day number of week (1 = Monday, …, 7 = Sunday) | Number | 1 |
a | Am/pm marker | Text | PM |
H | Hour in day (0-23) | Number | 0 |
k | Hour in day (1-24) | Number | 24 |
K | Hour in am/pm (0-11) | Number | 0 |
h | Hour in am/pm (1-12) | Number | 12 |
m | Minute in hour | Number | 30 |
s | Second in minute | Number | 55 |
S | Millisecond | Number | 978 |
z | Time zone | General time zone | Pacific Standard Time; PST; GMT-08:00 |
Z | Time zone | RFC 822 time zone | -0800 |
X | Time zone | ISO 8601 time zone | -08; -0800; -08:00 |