Links

Apply

A transform that accepts a custom template to execute. Must use the sql template argument source_table to reference the Rasgo dataset which will serve as the base of any SELECT

Parameters

Name
Type
Description
Is Optional
sql
custom
The custom SQL transform template to apply

Example

ds = rasgo.get.dataset(id)
ds2 = ds.apply(
sql='SELECT * FROM {{ source_table }} WHERE COLUMNVALUE = I17'
)
ds2.preview()
# passing in custom arguments
ds = rasgo.get.dataset(id)
ds2 = ds.apply(
sql="SELECT * FROM {{ source_table }} WHERE COLUMNVALUE = '{{ my_value }}'",
my_value="I17"
)
ds2.preview()

Source Code

Last modified 1yr ago