Eq JSONPath #
Instance details Defined in Napkin.Untyped.Ops.BigQuery Methods (==) :: JSONPath -> JSONPath -> Bool # (/=) :: JSONPath -> JSONPath -> Bool #
Ord JSONPath #
Instance details Defined in Napkin.Untyped.Ops.BigQuery Methods compare :: JSONPath -> JSONPath -> Ordering # (<) :: JSONPath -> JSONPath -> Bool # (<=) :: JSONPath -> JSONPath -> Bool # (>) :: JSONPath -> JSONPath -> Bool # (>=) :: JSONPath -> JSONPath -> Bool # max :: JSONPath -> JSONPath -> JSONPath # min :: JSONPath -> JSONPath -> JSONPath #
Show JSONPath #
Instance details Defined in Napkin.Untyped.Ops.BigQuery Methods showsPrec :: Int -> JSONPath -> ShowS # show :: JSONPath -> String # showList :: [JSONPath] -> ShowS #

jsonPath_key :: String -> JSONPath #

jsonPath_index :: Int -> JSONPath #

renderJSONPath :: [JSONPath] -> String #

jsonExtract :: SExp -> [JSONPath] -> SExp #

jsonExtractScalar :: SExp -> [JSONPath] -> SExp #

toJsonString #

Arguments

:: SExp
-> Maybe Bool	Pretty print
-> SExp

arrayConcat :: NonEmpty SExp -> SExp #

Array Functions

arrayLength :: SExp -> SExp #

arrayToString #

Arguments

:: SExp
-> String	Delimiter
-> Maybe String	Null text
-> SExp

generateArray #

Arguments

:: SExp	Start exp
-> SExp	End exp
-> Maybe SExp	Step exp
-> SExp

generateDateArray :: SExp -> SExp -> Maybe IntInterval -> SExp #

arrayReverse :: SExp -> SExp #

offset :: Int -> SExp -> SExp #

ordinal :: Int -> SExp -> SExp #

currentDate :: Maybe String -> SExp #

Date Functions

dateYMD #

Arguments

:: SExp	Year
-> SExp	Month
-> SExp	Day
-> SExp

dateTimestamp #

Arguments

:: SExp	Timestamp exp
-> Maybe SExp	Timezone exp
-> SExp

dateAdd #

Arguments

:: SExp	Date expression
-> IntInterval
-> SExp

dateSub #

Arguments

:: SExp	Date expression
-> IntInterval
-> SExp

dateDiff :: DatePart -> SExp -> SExp -> SExp #

dateTrunc :: DatePart -> SExp -> SExp #

dateFromUnixDate #

Arguments

:: SExp	Int64 expr
-> SExp

formatDate #

Arguments

:: SExp	Format string
-> SExp	Date expr
-> SExp

parseDate #

Arguments

:: SExp	Format string
-> SExp	Date expr
-> SExp

unixDate #

Arguments

:: SExp	Date expr
-> SExp

currentDatetime #

Arguments

:: Maybe SExp	Timezone
-> SExp

DateTime Functions

dateTimeYMDHMS #

Arguments

:: SExp	Year
-> SExp	Month
-> SExp	Day
-> SExp	Hour
-> SExp	Minute
-> SExp	Second
-> SExp

dateTimeDateAndTime #

Arguments

:: SExp	Date expression
-> SExp	Time expression
-> SExp

dateTimeTimestamp #

Arguments

:: SExp	Timestamp expression
-> Maybe SExp	Timezone expression
-> SExp

dateTimeAdd #

Arguments

:: SExp	Datetime expression
-> IntInterval
-> SExp

dateTimeSub #

Arguments

:: SExp	Datetime expression
-> IntInterval
-> SExp

dateTimeDiff :: DatePart -> SExp -> SExp -> SExp #

dateTimeTrunc :: DatePart -> SExp -> SExp #

formatDateTime #

Arguments

:: SExp	Format string
-> SExp	Datetime expression
-> SExp

parseDateTime #

Arguments

:: SExp	Format string
-> SExp	Datetime expression
-> SExp

currentTime :: SExp #

Time Functions

timeHMS #

Arguments

:: SExp	Hour
-> SExp	Minute
-> SExp	Second
-> SExp

timeTS #

Arguments

:: SExp	Timestamp
-> Maybe SExp	Time zone
-> SExp

timeAdd #

Arguments

:: SExp	Time expression
-> IntInterval
-> SExp

timeSub #

Arguments

:: SExp	Time expression
-> IntInterval
-> SExp

timeDiff :: DatePart -> SExp -> SExp -> SExp #

timeTrunc :: DatePart -> SExp -> SExp #

bqFormatTime #

Arguments

:: SExp	Format string
-> SExp	Time object
-> SExp

bqParseTime #

Arguments

:: SExp	Format string
-> SExp	Time object
-> SExp

currentTimestamp :: SExp #

Timestamp Functions

extract #

Arguments

:: DatePart
-> SExp	Timestamp expression
-> Maybe SExp	Time zone spec
-> SExp

string #

Arguments

:: SExp	Timestamp expression
-> Maybe SExp	Time zone
-> SExp

timestamp #

Arguments

:: SExp	string, date, or datetime expression
-> Maybe SExp	Time zone
-> SExp

timestampAdd :: SExp -> IntInterval -> SExp #

timestampSub :: SExp -> IntInterval -> SExp #

timestampDiff :: DatePart -> SExp -> SExp -> SExp #

timestampTrunc #

Arguments

:: DatePart
-> SExp	Timestamp expression
-> Maybe SExp	Time zone
-> SExp

formatTimestamp #

Arguments

:: SExp	Format string
-> SExp	Timestamp
-> Maybe SExp	Time zone
-> SExp

parseTimestamp #

Arguments

:: SExp	Format string
-> SExp	Timestamp
-> Maybe SExp	Time zone
-> SExp

timestampSeconds #

Arguments

:: SExp	Int64 expression
-> SExp

timestampMillis #

Arguments

:: SExp	Int64 expression
-> SExp

timestampMicros #

Arguments

:: SExp	Int64 expression
-> SExp

unixSeconds #

Arguments

:: SExp	Timestamp expression
-> SExp

unixMillis #

Arguments

:: SExp	Timestamp expression
-> SExp

unixMicros #

Arguments

:: SExp	Timestamp expression
-> SExp

sessionUser :: SExp #

Security Functions

netIPFromString #

Arguments

:: SExp	Addr string
-> SExp

Net Functions

netSafeIPFromString #

Arguments

:: SExp	Addr string
-> SExp

Like netIPFromString but returns NULL rather than throwing on error.

netIPToString #

Arguments

:: SExp	Addr binary
-> SExp

netIPNetMask #

Arguments

:: SExp	Num output bytes
-> SExp	Prefix length
-> SExp

netIPTrunc #

Arguments

:: SExp	Addr binary
-> SExp	Prefix length
-> SExp

netIPV4FromInt64 #

Arguments

:: SExp
-> SExp	Addr binary

netIPV4ToInt64 #

Arguments

:: SExp	Addr binary
-> SExp

netHost #

Arguments

:: SExp	URL
-> SExp

netPublicSuffix #

Arguments

:: SExp	URL
-> SExp

netRegDomain #

Arguments

:: SExp	URL
-> SExp

coalesce :: [SExp] -> SExp #

Conditional Expressions

ifnull #

Arguments

:: SExp	Expressoin
-> SExp	Null result
-> SExp

nullif #

Arguments

:: SExp	Expression
-> SExp	Expression to match
-> SExp

like :: SExp -> SExp -> SExp #

Comparison operators

between :: SExp -> SExp -> SExp -> SExp #

scope :: SExp -> SExp -> SExp #

Higher level combinators

scoped :: SExp -> SExp -> SExp #

inferAgg :: SExp -> AggLevel #

unitBoundary :: SExp -> [SExp] #

modifyUnitBoundary :: (SExp -> SExp) -> SExp -> SExp #

bigQueryMeta :: BackendFunctionMeta #

bigQueryAggs :: [(Ref Function, SExp)] #

textInfix :: SExp -> SExp -> SExp #

Is text a contained in text b?

nullIfEmpty :: SExp -> SExp #

Replace empty string with NULL

seekBackIgnoreNulls :: SExp -> Int -> WOver -> SExp #

Use nthValue under the hood with IgnoreNulls, set window frame to start at current row (so nth-value can index) and flip the ordering in given OVER clause so that it semantically behaves like lag but with ignore nulls functionality.

It will start with current row, so setting to 1 will just return current row's value.

seekForwardIgnoreNulls :: SExp -> Int -> WOver -> SExp #

Same deal as lagIgnorenulls but doesn't need to flip the ordering in OVER clause as lead and nthValue both naturally operate in ascending order.

lagIgnoreNulls :: SExp -> Int -> WOver -> SExp #

BigQuery can't ignore nulls while lagging/leading. Use the seekBackignorenulls machinery intelligently to mimic a proper lag with ignore nulls.

leadIgnoreNulls :: SExp -> Int -> WOver -> SExp #

denseAvg :: SExp -> SExp #

weightedAvg :: SExp -> SExp -> SExp #

nzAvg :: SExp -> SExp #

percentDiff :: SExp -> SExp -> SExp #

percent difference of a over b with typecast to Double

data SubQueryTransformState #

Constructors

SubQueryTransformState
Fields _subQueryTransformState_refs :: RefStore _subQueryTransformState_mapping :: Map SExp (Ref SExp)

Instances

Instances details

Default SubQueryTransformState #
Instance details Defined in Napkin.Untyped.Ops.BigQuery Methods def :: SubQueryTransformState #
HasRefStore SubQueryTransformState #
Instance details Defined in Napkin.Untyped.Ops.BigQuery Methods refRepo :: Lens' SubQueryTransformState RefStore #

subQueryTransformState_refs :: Lens' SubQueryTransformState RefStore #

subQueryTransformState_mapping :: Lens' SubQueryTransformState (Map SExp (Ref SExp)) #

subqueryTransform :: Query -> Query #

humanAge :: SExp -> SExp -> SExp #

Calculates the year-based human age given a "current date" and a date in the past. Returns float-based age. DATE_DIFF(CURRENT_DATE, cast('1990-01-01' as date), YEAR) + IF(EXTRACT(DAYOFYEAR FROM CURRENT_DATE) < EXTRACT(DAYOFYEAR FROM cast('1990-01-01' as date)), -1, 0)