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