Spider 2.0

https://github.com/xlang-ai/spider2
Admin
Spider 2.0 is a comprehensive text-to-SQL and code agent benchmark evaluating language models on...
Tokens:9,045,188
Snippets:51,750
Trust Score:7.9
License:MIT
Update:4 months ago
Show doc for...
Tokens:
Raw
### Example: Google Play Installs Model

Source: https://github.com/xlang-ai/spider2/blob/main/spider2-dbt/examples/app_reporting002/dbt_packages/google_play/docs/index.html

This example shows the SQL code for the `google_play_installs` model, which likely processes raw install data from Google Play.

```sql
SELECT
    CAST(date AS DATE) AS date,
    package_name,
    installs,
    uninstalls,
    device_type,
    country,
    device_brand,
    device_model
FROM
    {{ source('google_play', 'installs') }}
```

--------------------------------

### Aggregate Data: Total Installs by App

Source: https://github.com/xlang-ai/spider2/blob/main/spider2-dbt/examples/app_reporting001/dbt_packages/google_play_source/docs/index.html

Example of aggregating data to calculate the total number of installs for each application.

```sql
select
    app_name,
    sum(installs) as total_installs
from {{ source('google_play_source', 'your_google_play_table') }}
group by 1
order by 2 desc
```

--------------------------------

### Example: Get App Installation Counts

Source: https://github.com/xlang-ai/spider2/blob/main/spider2-dbt/examples/app_reporting002/dbt_packages/google_play/docs/index.html

Query the `app_installations` model to retrieve daily installation counts for your applications. This model aggregates data from the raw Play Store data.

```sql
SELECT
    date,
    package_name,
    installs
FROM
    {{ ref('app_installations') }}
WHERE
    package_name = 'com.example.app'
ORDER BY
    date DESC
LIMIT 100;
```

--------------------------------

### Example SQL for staging Google Play installs

Source: https://github.com/xlang-ai/spider2/blob/main/spider2-dbt/examples/app_reporting001/dbt_packages/google_play_source/docs/index.html

A SQL query to stage the Google Play installs data, selecting key metrics and joining with app information.

```sql
select
  app_id,
  date,
  installs,
  uninstalls,
  device_installs,
  uninstall_events
from {{ source('google_play_source', 'installs') }}
```

--------------------------------

### Example: Selecting from Installs Table

Source: https://github.com/xlang-ai/spider2/blob/main/spider2-dbt/examples/google_play001/dbt_packages/google_play_source/docs/index.html

This SQL snippet demonstrates how to select data from the 'installs' table within the 'google_play_raw' source. It filters for a specific date range.

```sql
SELECT
    install_id,
    app_id,
    install_date,
    installs
FROM
    {{ source('google_play_raw', 'installs') }}
WHERE
    install_date BETWEEN '2023-01-01' AND '2023-12-31'
```

--------------------------------

### Router and $get Initialization

Source: https://github.com/xlang-ai/spider2/blob/main/spider2-dbt/examples/greenhouse001/dbt_packages/greenhouse_source/docs/index.html

Initializes runtime services and sets up the router and $get function. This is a core part of the router's setup.

```javascript
function n(e,n,r,i,o,a,s){return t._runtimeServices(o,e,i,n,r),delete b.router,delete b.$get,b}
```

--------------------------------

### Example: Creating a dbt model for Google Play Installs

Source: https://github.com/xlang-ai/spider2/blob/main/spider2-dbt/examples/google_play001/dbt_packages/google_play_source/docs/index.html

This SQL model selects and transforms data from the raw_google_play__installs source table. It focuses on providing a clean dataset for analyzing install trends.

```sql
-- models/google_play/installs.sql

{{ config(materialized='table') }}

select
    install_id,
    app_id,
    install_date,
    device_id,
    country
from {{ source('google_play', 'raw_google_play__installs') }}
where install_id is not null
```

--------------------------------

### Example of a dbt model for daily installs

Source: https://github.com/xlang-ai/spider2/blob/main/spider2-dbt/examples/app_reporting001/dbt_packages/google_play_source/docs/index.html

This snippet defines a dbt model for daily installs. It selects relevant columns and filters by report date, suitable for incremental loading.

```sql
select
    id,
    report_date,
    installs,
    uninstalls,
    revenue,
    rating_count,
    rating_average
from
    {{ source('google_play', 'daily_installs') }}
where
    report_date >= date('{{ var("start_date") }}')
```

--------------------------------

### Example of a dbt model for daily device installs

Source: https://github.com/xlang-ai/spider2/blob/main/spider2-dbt/examples/app_reporting001/dbt_packages/google_play_source/docs/index.html

This snippet defines a dbt model for daily device installs. It selects essential columns and filters by report date, supporting incremental data loading.

```sql
select
    id,
    report_date,
    installs,
    uninstalls,
    revenue,
    rating_count,
    rating_average
from
    {{ source('google_play', 'daily_device_installs') }}
where
    report_date >= date('{{ var("start_date") }}')
```

--------------------------------

### Get Animation Start Style

Source: https://github.com/xlang-ai/spider2/blob/main/spider2-dbt/examples/greenhouse001/dbt_packages/greenhouse_source/docs/index.html

Determines the starting style values for an animation. Parses string values into their internal representations. Used internally for animation setup.

```javascript
getAnimationStartStyle: function(e, t) {
  for (var n = {}, r = 0; r < t.length; r++) {
    var o = t[r].name,
      a = e.pstyle(o);
    void 0 !== a && (a = i.plainObject(a) ? this.parse(o, a.strValue) : this.parse(o, a)),
    a && (n[o] = a)
  }
  return n
}
```

--------------------------------

### Example: Joining Campaign and Metrics

Source: https://github.com/xlang-ai/spider2/blob/main/spider2-dbt/examples/google_ads001/dbt_packages/google_ads_source/docs/index.html

Demonstrates how to join campaign details with daily performance metrics to create a more comprehensive view.

```sql
-- models/marts/core/dim_google_ads_campaigns.sql

with campaigns as (
  select * from {{ ref('stg_google_ads__campaigns') }}
),

metrics as (
  select * from {{ ref('stg_google_ads__metrics') }}
)

select
  c.campaign_id,
  c.campaign_name,
  c.campaign_status,
  m.date,
  sum(m.clicks) as total_clicks,
  sum(m.impressions) as total_impressions,
  sum(m.cost) as total_cost,
  sum(m.conversions) as total_conversions
from campaigns c
join metrics m
  on c.campaign_id = m.campaign_id
group by 1, 2, 3, 4
```

--------------------------------

### Get Next Week's Start Date

Source: https://github.com/xlang-ai/spider2/blob/main/spider2-dbt/examples/inzight001/dbt_packages/dbt_date/README.md

Convenience function to get the start date of the next week (non-ISO). The timezone can be optionally overridden.

```sql
{{ dbt_date.next_week()) }} as next_week_start_date
```

```sql
{{ dbt_date.next_week(tz="America/New_York") }}  as next_week_start_date
```

--------------------------------

### Main Application Controller Setup

Source: https://github.com/xlang-ai/spider2/blob/main/spider2-dbt/examples/app_reporting002/dbt_packages/apple_store/docs/index.html

Initializes the main application controller, setting up project structure, search functionality, and event listeners. It handles model tree loading, state transitions, and user tracking.

```javascript
function(e,t,n){"use strict";const r=n(8),i=n(21),o=n(33),a=n(461);n(462),n(206),n(470),n(472),n(475),n(479),r.module("dbt").controller("MainController",["$scope","$route","$state","project","graph","selectorService","trackingService","locationService","$transitions",function(e,t,n,r,s,l,c,u,d){function p(t){e.model_uid=t;var n=r.node(t);n&&l.resetSelection(n)}function f(e){e&&setTimeout((function(){var t=o("*["data-nav-unique-id='"+e+"'"]");t.length&&t[0].scrollIntoView&&t[0].scrollIntoView({behavior:"smooth",block:"center",inline:"center"})}),1)}e.tree={database:{},project:{},sources:{}},e.search={query:"",results:[],is_focused:!1},e.logo=a,e.model_uid=null,e.project={},o("body").bind("keydown",(function(e){"t"==event.key&&"INPUT"!=event.target.tagName&&(o("#search").focus(),event.preventDefault())})),e.onSearchFocus=function(t,n){e.search.is_focused=n},e.clearSearch=function(){e.search.is_focused=!1,e.search.query="",e.search.results=[],o("#search").blur()},e.$on("clearSearch",(function(){e.clearSearch()})),e.$on("query",(function(t,n){e.search.is_focused=!0,e.search.query=n})),e.onSearchKeypress=function(t){"Escape"==t.key&&(e.clearSearch(),t.preventDefault())},r.getModelTree(n.params.unique_id,(function(t){e.tree.database=t.database,e.tree.project=t.project,e.tree.sources=t.sources,e.tree.exposures=t.exposures,e.tree.metrics=t.metrics,e.tree.semantic_models=t.semantic_models,e.tree.saved_queries=t.saved_queries,e.tree.groups=t.groups,setTimeout((function(){f(e.model_uid)}))})),d.onSuccess({},(function(t,n){var i=t.router.globals.params,o=l.getViewNode(),a=o?o.unique_id:null,s=i.unique_id,u=!0;if(t.from().name==t.to().name&&a==s&&(u=!1),u&&i.unique_id){var d=r.updateSelected(i.unique_id);e.tree.database=d.database,e.tree.groups=d.groups,e.tree.project=d.project,e.tree.sources=d.sources,e.search.query="",p(i.unique_id),setTimeout((function(){f(i.unique_id)}))}u&&c.track_pageview()})),e.$watch("search.query",(function(t){e.search.results=function(t){if(""===e.search.query)return t;let n={name:10,tags:5,description:3,raw_code:2,columns:1};return i.each(t,(function(t){t.overallWeight=0,i.each(Object.keys(n),(function(r){if(null!=t.model[r]){let o=0,a=t.model[r],s=e.search.query.toLowerCase();if("columns"===r)i.each(a,(function(e){if(e.name){let t=e.name.toLowerCase(),n=0;for(;-1!=n;)n=t.indexOf(s,n),-1!=n&&(o++,n++)}}));else if("tags"===r)i.each(a,(function(e){let t=e.toLowerCase(),n=0;for(;-1!=n;)n=t.indexOf(s,n),-1!=n&&(o++,n++)}));else{a=a.toLowerCase();let e=0;for(;-1!=e;)e=a.indexOf(s,e),-1!=e&&(o++,e++)}t.overallWeight+=o*n[r]}}))})),t}(r.search(t))})),r.init(),r.ready((function(t){e.project=t,e.search.results=r.search("");var o=i.unique(i.pluck(i.values(t.nodes),"package_name")).sort(),a=[null];i.each(t.nodes,(function(e){var t=e.tags;a=i.union(a,t).sort()})),l.init({packages:o,tags:a}),p(n.params.unique_id);var d=u.parseState(n.params);d.show_graph&&s.ready((function(){i.assign(l.selection.dirty,d.selected);var e=l.updateSelection();s.updateGraph(e)}));var f=t.metadata||{};c.init({track:f.send_anonymous_usage_stats,project_id:f.project_id})}))}"}),
```

--------------------------------

### Get Last Week's Start Date

Source: https://github.com/xlang-ai/spider2/blob/main/spider2-dbt/examples/inzight001/dbt_packages/dbt_date/README.md

Convenience function to get the start date of the last week (non-ISO). The timezone can be optionally overridden.

```sql
{{ dbt_date.last_week()) }} as last_week_start_date
```

```sql
{{ dbt_date.last_week(tz="America/New_York)) }} as last_week_start_date
```

--------------------------------

### Get Last Week Start Date

Source: https://github.com/xlang-ai/spider2/blob/main/spider2-dbt/examples/shopify002/dbt_packages/dbt_date/README.md

Convenience function to get the start date of last week. Uses the default timezone. This is a wrapper for n_weeks_ago(1).

```sql
{{ dbt_date.last_week()) }} as last_week_start_date
```

--------------------------------

### Serve Google Play Documentation

Source: https://github.com/xlang-ai/spider2/blob/main/spider2-dbt/examples/app_reporting002/dbt_packages/google_play/docs/index.html

Serve the generated dbt documentation locally to view it in your web browser. This command starts a local web server.

```bash
dbt docs serve
```

--------------------------------

### Get Last Week Start Date with Timezone

Source: https://github.com/xlang-ai/spider2/blob/main/spider2-dbt/examples/shopify002/dbt_packages/dbt_date/README.md

Convenience function to get the start date of last week, overriding the default timezone. This is a wrapper for n_weeks_ago(1).

```sql
{{ dbt_date.last_week(tz="America/New_York)) }} as last_week_start_date
```

--------------------------------

### Define $get for Router

Source: https://github.com/xlang-ai/spider2/blob/main/spider2-dbt/examples/social_media001/dbt_packages/linkedin_pages/docs/index.html

Defines the $get function for the router, which is part of the dependency injection setup.

```javascript
b.$get=n,$inject=["$location","$browser","$window","$sniffer","$rootScope","$http","$templateCache"];
```

--------------------------------

### Document Setup Function

Source: https://github.com/xlang-ai/spider2/blob/main/spider2-dbt/examples/app_reporting002/dbt_packages/apple_store/docs/index.html

Initializes the document context and sets up support flags for the selector engine.

```javascript
p=se.setDocument=function(e){var t,i,a=e?e.ownerDocument||e:w;return a!=f&&9===a.nodeType&&a.documentElement?(h=(f=a).documentElement,g=!o(f),w!=f&&(i=f.defaultView)&&i.top!==i&&(i.addEventListener?i.addEventListener("unload",oe,!1):i.attachEvent&&i.attachEvent("onunload",oe)),n.scope=ue((function(e){return h.appendChild(e).appendChild(f.createElement("div")),void 0!==e.querySelectorAll&&!e.querySelectorAll(":scope fieldset div").length})),n.attributes=ue((function(e){return e.className="i",!e.getAttribute("className")})),n.getElementsByTagName=ue((function(e){return e.appendChild(f.createComment("")),!e.getElementsByTagName("*" ).length})),n.getElementsByClassName=J.test(f.getElementsByClassName),n.getById=ue((function(e){return h.appendChild(e).id=x,!f.getElementsByName||!f.getElementsByName(x).length})),n.getById?(r.filter.ID=function(e){var t=e.replace(te,ne);return function(e){return e.getAttribute("id")===t}},r.find.ID=function(e,t){if(void 0!==t.getElementById&&g){var n=t.getElementById(e);return n?[n]:[]}}):(r.filter.ID=function(e){var t=e.replace(te,ne);return function(e){var n=vo
```

--------------------------------

### Example: Customizing `dbt_project.yml` for Salesforce Models

Source: https://github.com/xlang-ai/spider2/blob/main/spider2-dbt/examples/salesforce001/dbt_packages/salesforce_source/docs/index.html

Demonstrates how to set global configurations for all Salesforce models, such as tags and materialization, within the `dbt_project.yml` file.

```yaml
models:
  salesforce_source:
    +materialized: table
    +tags: ["salesforce_data"]
```

--------------------------------

### Setup Spider 2.0-Snow

Source: https://github.com/xlang-ai/spider2/blob/main/methods/spider-agent-snow/README.md

Execute the setup script for Spider 2.0-Snow after installing dependencies and configuring Snowflake credentials.

```python
python spider_agent_setup_snow.py
```

--------------------------------

### Get Last Month Start Date

Source: https://github.com/xlang-ai/spider2/blob/main/spider2-dbt/examples/shopify002/dbt_packages/dbt_date/README.md

Returns the start date of the prior month. Uses the default timezone.

```sql
{{ dbt_date.last_month() }} as last_month_start_date
```

--------------------------------

### Example: Joining QuickBooks Tables

Source: https://github.com/xlang-ai/spider2/blob/main/spider2-dbt/examples/quickbooks001/dbt_packages/quickbooks_source/docs/index.html

Illustrates how to join different tables from the QuickBooks source to gain deeper insights. This example joins invoices with customers.

```sql
select
    i.invoice_id,
    i.invoice_number,
    i.total_amount,
    c.customer_name,
    c.email
from {{ source('quickbooks', 'invoices') }} as i
join {{ source('quickbooks', 'customers') }} as c
  on i.customer_id = c.customer_id
where i.status = 'Open'
```

--------------------------------

### Example SQL Query for Daily App Performance

Source: https://github.com/xlang-ai/spider2/blob/main/spider2-dbt/examples/google_play002/dbt_packages/google_play_source/docs/index.html

This snippet shows how to query daily app performance metrics. It selects key performance indicators like installs, uninstalls, and revenue from the daily app performance model.

```sql
SELECT
    date,
    app_name,
    installs,
    uninstalls,
    revenue
FROM
    google_play_source.daily_app_performance
WHERE
    date BETWEEN '2023-01-01' AND '2023-01-31'
ORDER BY
    date DESC;
```

--------------------------------

### Get Last Month Start Date with Timezone

Source: https://github.com/xlang-ai/spider2/blob/main/spider2-dbt/examples/shopify002/dbt_packages/dbt_date/README.md

Returns the start date of the prior month, overriding the default timezone.

```sql
{{ dbt_date.last_month(tz="America/New_York") }} as last_month_start_date
```

--------------------------------

### Model Configuration Example

Source: https://github.com/xlang-ai/spider2/blob/main/spider2-dbt/examples/app_reporting001/dbt_packages/google_play_source/docs/index.html

Shows how to configure a dbt model using materialization and schema settings.

```sql
{{ config(materialized='table', schema='staging') }}

SELECT
  id,
  name,
  created_at
FROM
  {{ source('raw_data', 'users') }}
```

--------------------------------

### Get Next Month's Start Date

Source: https://github.com/xlang-ai/spider2/blob/main/spider2-dbt/examples/inzight001/dbt_packages/dbt_date/README.md

Returns the start date of the next month. The timezone can be optionally overridden.

```sql
{{ dbt_date.next_month() }} as next_month_start_date
```

```sql
{{ dbt_date.next_month(tz="America/New_York") }} as next_month_start_date
```

--------------------------------

### Get Last Month's Start Date

Source: https://github.com/xlang-ai/spider2/blob/main/spider2-dbt/examples/inzight001/dbt_packages/dbt_date/README.md

Returns the start date of the prior month. The timezone can be optionally overridden.

```sql
{{ dbt_date.last_month() }} as last_month_start_date
```

```sql
{{ dbt_date.last_month(tz="America/New_York") }} as last_month_start_date
```

--------------------------------

### Configuration Example

Source: https://github.com/xlang-ai/spider2/blob/main/spider2-dbt/examples/inzight001/dbt_packages/dbt_expectations/docs/index.html

Shows how to configure dbt-expectations in your dbt project's `dbt_project.yml` file.

```yaml
models:
  dbt_expectations:
    +store_failures: true
    +warn_business_criticality: true
```

--------------------------------

### Pad Start Example

Source: https://github.com/xlang-ai/spider2/blob/main/spider2-dbt/examples/google_ads001/dbt_packages/google_ads_source/docs/index.html

Pads `string` start with `chars` to achieve a given `length`. If `padding` is unspecified, it defaults to a space.

```javascript
On.padStart = function(e, t, n) {
  e = ls(e);
  var r = (t = is(t))
```

--------------------------------

### Example: Basic Usage

Source: https://github.com/xlang-ai/spider2/blob/main/spider2-dbt/examples/google_play002/dbt_packages/google_play_source/docs/index.html

This example demonstrates the basic usage of the google_play_source package to extract data from Google Play.

```sql
-- models/staging/stg_google_play__installs.sql

SELECT
    * 
FROM
    {{ source('google_play_source', 'installs') }}
```

--------------------------------

### Example SQL Query for Daily Store Listing Performance

Source: https://github.com/xlang-ai/spider2/blob/main/spider2-dbt/examples/google_play002/dbt_packages/google_play_source/docs/index.html

This snippet shows how to query daily store listing performance metrics. It includes data on impressions, page views, and installs directly from the store listing.

```sql
SELECT
    date,
    impressions,
    page_views,
    installs
FROM
    google_play_source.daily_store_listing_performance
WHERE
    date >= '2023-01-01'
ORDER BY
    date DESC;
```

--------------------------------

### Marketo Source Package Setup

Source: https://github.com/xlang-ai/spider2/blob/main/spider2-dbt/examples/marketo001/dbt_packages/marketo_source/docs/index.html

This snippet shows the basic setup for the Marketo source package. It assumes you have dbt installed and configured.

```html
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Marketo Source Package</title>
    <link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/water.css@2/out/water.css">
</head>
<body>
    <h1>Marketo Source Package</h1>
    <p>This is the main documentation page for the Marketo source package.</p>

    <h2>Getting Started</h2>
    <p>To use this package, ensure you have dbt installed and have configured your Marketo connection details in your <code>profiles.yml</code> file.</p>

    <h2>Configuration</h2>
    <p>The package can be configured via your <code>dbt_project.yml</code> file. Here is an example:</p>
    <pre><code class="language-yaml">
package-install-path: ../../dbt_packages

packages:
  - package: marketo_source
    version: "0.1.0"

vars:
  marketo_schema: "your_marketo_schema"
  marketo_database: "your_marketo_database"
  marketo_client_id: "your_client_id"
  marketo_client_secret: "your_client_secret"
  marketo_api_url: "https://your_api_url.mktorest.com"
  marketo_api_version: "v1"
  marketo_start_date: "2023-01-01"
</code></pre>

    <h2>Models</h2>
    <p>The package includes several models to extract and transform Marketo data. Key models include:</p>
    <ul>
        <li><code>stg_marketo__campaign</code></li>
        <li><code>stg_marketo__lead</code></li>
        <li><code>stg_marketo__activity</code></li>
    </ul>

    <h2>Usage Example</h2>
    <p>To run the models, use the following dbt command:</p>
    <pre><code class="language-bash">
dbt run --select marketo_source
</code></pre>

    <h2>Customization</h2>
    <p>You can override default configurations by defining variables in your <code>dbt_project.yml</code> or by passing them as arguments to the <code>dbt run</code> command.</p>

</body>
</html>

```

--------------------------------

### Example: Using a Macro

Source: https://github.com/xlang-ai/spider2/blob/main/spider2-dbt/examples/google_play002/dbt_packages/google_play_source/docs/index.html

Illustrates how to use a macro provided by the package. This macro helps in formatting dates.

```sql
SELECT
    {{ google_play_source.format_date('your_date_column') }} AS formatted_date
FROM
    {{ source('google_play_source', 'raw_data') }}
```

--------------------------------

### Get Last Day of Week (Starts Monday)

Source: https://github.com/xlang-ai/spider2/blob/main/spider2-lite/resource/syntax/bigquery_documentation/datetime_functions.txt

Returns the last day of the week for a week that starts on a Monday, using WEEK(MONDAY).

```sql
SELECT LAST_DAY(DATETIME '2008-11-10 15:30:00', WEEK(MONDAY)) AS last_day
```

--------------------------------

### Example: Using a Staging Model for Greenhouse Data

Source: https://github.com/xlang-ai/spider2/blob/main/spider2-dbt/examples/greenhouse001/dbt_packages/greenhouse_source/docs/index.html

Shows how to create a staging model that leverages the greenhouse_source package. This model selects and renames fields from the 'jobs' source.

```sql
select
    job_id as id,
    name as job_name,
    status
from {{ source('greenhouse_source', 'jobs') }}
```

--------------------------------

### Example: Using a Specific Table

Source: https://github.com/xlang-ai/spider2/blob/main/spider2-dbt/examples/google_play002/dbt_packages/google_play_source/docs/index.html

This example shows how to select and use a specific table from the google_play_source package, such as 'reviews'.

```sql
-- models/staging/stg_google_play__reviews.sql

SELECT
    * 
FROM
    {{ source('google_play_source', 'reviews') }}
```

--------------------------------

### Get Last Day of Week (Starts Sunday)

Source: https://github.com/xlang-ai/spider2/blob/main/spider2-lite/resource/syntax/bigquery_documentation/datetime_functions.txt

Returns the last day of the week for a week that starts on a Sunday, using WEEK(SUNDAY).

```sql
SELECT LAST_DAY(DATETIME '2008-11-10 15:30:00', WEEK(SUNDAY)) AS last_day
```

--------------------------------

### Salesforce Source Configuration Example

Source: https://github.com/xlang-ai/spider2/blob/main/spider2-dbt/examples/salesforce001/dbt_packages/salesforce_source/docs/index.html

Example of how to configure the Salesforce source in dbt. This includes specifying the package name, source name, and the tables to be included.

```yaml
sources:
  - name: salesforce
    schema: "{{ var('salesforce_schema') }}"
    tables:
      - name: account
      - name: campaign
      - name: campaign_member
      - name: case
      - name: contact
      - name: lead
      - name: opportunity
      - name: task
      - name: user
```

--------------------------------

### Get Animation Start Style

Source: https://github.com/xlang-ai/spider2/blob/main/spider2-dbt/examples/app_reporting001/dbt_packages/apple_store/docs/index.html

Determines the starting style values for an animation on a Cytoscape element. Parses style values into their computed forms.

```javascript
getAnimationStartStyle:function(e,t){
for(var n={},r=0;r<t.length;r++){
var o=t[r].name,
a=e.pstyle(o);
void 0!==a&&(a=i.plainObject(a)?this.parse(o,a.strValue):this.parse(o,a)),a&&(n[o]=a)
}
return n
}
```

--------------------------------

### HTTP GET Request Example

Source: https://github.com/xlang-ai/spider2/blob/main/spider2-dbt/examples/app_reporting002/dbt_packages/google_play/docs/index.html

Demonstrates how to make an HTTP GET request using the module. Ensure the module is properly initialized before use.

```javascript
function get(url, config) {
  return $http(angular.extend({url: url, method: 'GET'}, config));
}
```

--------------------------------

### UI Router Initialization and Dependency Injection Setup

Source: https://github.com/xlang-ai/spider2/blob/main/spider2-dbt/examples/recharge002/dbt_packages/recharge_source/docs/index.html

Initializes the UI Router, sets up the injector, and configures strict dependency injection based on invocation errors.

```javascript
function w(e,t,n){if(i.services.$injector=e,i.services.$q=t,!Object.prototype.hasOwnProperty.call(e,"strictDi"))try{e.invoke((function(e){}))}catch(t){e.strictDi=!!/strict mode/.exec(t&&t.toString())}n.stateRegistry.get().map((function(e){return e.$$state().resolvables})).reduce(i.unnestR,[])
```

--------------------------------

### Get Last Day of Week (Monday Start) in BigQuery

Source: https://github.com/xlang-ai/spider2/blob/main/spider2-lite/resource/syntax/bigquery_documentation/date_functions.txt

Returns the last day of the week for a given date, where the week is defined as starting on Monday.

```sql
SELECT LAST_DAY(DATE '2008-11-10', WEEK(MONDAY)) AS last_day
```

--------------------------------

### Initialize and Load Quickbooks Source Project

Source: https://github.com/xlang-ai/spider2/blob/main/spider2-dbt/examples/quickbooks003/dbt_packages/quickbooks_source/docs/index.html

This snippet demonstrates how to initialize the dbt project and load the manifest and catalog JSON files. It processes nodes, sources, exposures, metrics, and semantic models, and also handles macro loading and filtering.

```javascript
const c=n(9),u=(n(33),n(202)),{getQuoteChar:d}=n(430);
c.module("dbt").factory("project",["$q","$http",function(e,t){
var n={"manifest":"MANIFEST.JSON INLINE DATA","catalog":"CATALOG.JSON INLINE DATA"};
var r={"project":{},"tree":{"project":[],"database":[],"sources":[]},"files":{"manifest":{},"catalog":{}},"loaded":e.defer()
};

function i(e,t){return u.each(t.sources,(function(e,n){t.nodes[n]=e})),u.each(e.nodes,(function(e,n){var r=t.nodes[n];if(r){var i,o,a,s=u.keys(r.columns),l=e.columns,c=(i=s,o=l,a={},u.each(o,(function(e,t){var n=u.find(i,(function(e){return e.toLowerCase()==t.toLowerCase()}));n?a[n]=e:a[t]=e})),a);e.columns=c}})),l(t,e)}
function o(e,r){return e in n&&"object"==typeof n[e]?{label:e,data:n[e]}:t({method:"GET",url:r}).then((function(t){return{label:e,data:t.data}}),(function(t){console.error(t),alert("dbt Docs was unable to load the "+e+" file at path: \n "+r+"\n\nError: "+t.statusText+" ("+t.status+")\n\nThe dbt Docs site may not work as expected if this file cannot be found.Please try again, and contact support if this error persists.")}))}

return r.find_by_id=function(e,t){r.ready((function(){if(e){var n=r.node(e);t(n)}}))},
r.node=function(e){return u.find(r.project.nodes,{unique_id:e})},
r.loadProject=function(){var t="?cb="+(new Date).getTime(),n=[o("manifest","manifest.json"+t),o("catalog","catalog.json"+t)];

e.all(n).then((function(e){u.each(e,(function(e){e?r.files[e.label]=e.data:console.error("FILE FAILED TO LOAD!")})),
u.each(r.files.manifest.nodes,(function(e){"model"==e.resource_type&&null!=e.version?e.label=e.name+"_v"+e.version:e.label=e.name})),
u.each(r.files.manifest.sources,(function(e){e.label=e.source_name+"."+e.name,r.files.manifest.nodes[e.unique_id]=e})),
u.each(r.files.manifest.exposures,(function(e){e.label||(e.label=e.name),r.files.manifest.nodes[e.unique_id]=e})),
u.each(r.files.manifest.metrics,(function(e){r.files.manifest.nodes[e.unique_id]=e})),
u.each(r.files.manifest.semantic_models,(function(e){r.files.manifest.nodes[e.unique_id]=e,e.label=e.name}));

var t=r.files.manifest.metadata.adapter_type,n=function(e,t){var n=e||[],r={};u.each(n,(function(e){r[e.package_name]||(r[e.package_name]={}),r[e.package_name][e.name]=e}));e=[];
return u.each(r,(function(n,r){if("dbt"!=r&&r!="dbt_"+t){var i=function(e,t){var n={};u.each(e,(function(e){e.macro_sql.match(/{{\s*adapter_macro\([^)]+\)\s+}}/)&&(e.impls={"Adapter Macro":e.macro_sql},e.is_adapter_macro=!0,n[e.name]=e)});var r=["postgres","redshift","bigquery","snowflake","spark","presto","default"],i=u.values(n),o=u.filter(e,(function(e){var t=e.name.split("__"),i=t.shift(),o=t.join("__");return!(r.indexOf(i)>=0&&n[o])||(n[o].impls[i]=e.macro_sql,e.is_adapter_macro_impl=!0,!1)}))};return i.concat(o)}(n);e=e.concat(i)}})),u.keyBy(e,"unique_id")}(r.files.manifest.macros,t);
r.files.manifest.macros=n;

var o=i(r.files.manifest,r.files.catalog),a=o.nodes,s=u.keyBy(a,"name"),l=u.filter(o.nodes,{resource_type:"test"});

u.each(l,(function(e){if(e.hasOwnProperty("test_metadata")){var t,n={test_name:t=e.test_metadata.namespace?e.test_metadata.namespace+"."+e.test_metadata.name:e.test_metadata.name};

if("not_null"==e.test_metadata.name)n.short="N",n.label="Not Null";else if("unique"==e.test_metadata.name)n.short="U",n.label="Unique";else if("relationships"==e.test_metadata.name){var r=e.refs[0],i=s[r];i&&e.test_metadata.kwargs.field&&(n.fk_field=e.test_metadata.kwargs.field,n.fk_model=i),n.short="F",n.label="Foreign Key"}else if("accepted_values"==e.test_metadata.name){if(Array.isArray(e.test_metadata.kwargs.values))var a=e.test_metadata.kwargs.values.join(", ");else a=JSON.stringify(e.test_metadata.kwargs.values);n.short="A",n.label="Accepted Values: "+a}else{var l=u.omit(e.test_metadata.kwargs,"column_name");n.short="+",n.label=t+"("+JSON.stringify(l)+")"}}

var c=e.depends_on.nodes,p=e.column_name||e.test_metadata.kwargs.column_name||e.test_metadata.kwargs.arg;
if(c.length&&p){if("relationships"==e.test_metadata.name)var f=c[c.length-1];else f=c[0];var h=o.nodes[f],g=d(o.metadata),m=u.find(h.columns,(function(e,t){let n=p;return p.startsWith(g)&&p.endsWith(g)&&(n=p.substring(1,p.length-1)),t.toLowerCase()==n.toLowerCase()}));m&&(m.tests=m.tests||[],m.tests.push(n))}}})),
r.project=o;

var c=u.filter(r.project.macros,(function(e){return!e.is_adapter_macro_impl})),p=u.filter(r.project.nodes,(function(e){return u.includes(["model","source","seed","snapshot","analysis","exposure","metric","semantic_model"],e.resource_type)}));
r.project.searchable=u.filter(p.concat(c),(function(e){return!e.docs||e.docs.show})),
r.loaded.resolve()}))
},
r.ready=function(e){r.loaded.promise.then((function(){e(r.project)}))},
r.search=function(e){if(0==e.length)return u.ma
```

--------------------------------

### Get Last Day of Week (Sunday Start) in BigQuery

Source: https://github.com/xlang-ai/spider2/blob/main/spider2-lite/resource/syntax/bigquery_documentation/date_functions.txt

Returns the last day of the week for a given date, where the week is defined as starting on Sunday.

```sql
SELECT LAST_DAY(DATE '2008-11-10', WEEK(SUNDAY)) AS last_day
```

--------------------------------

### Get Animation Start Style

Source: https://github.com/xlang-ai/spider2/blob/main/spider2-dbt/examples/lever001/dbt_packages/lever_source/docs/index.html

Determines the starting style values for an animation based on the current element styles. Used to calculate animation deltas.

```javascript
getAnimationStartStyle:function(e,t){for(var n={},r=0;r<t.length;r++){var o=t[r].name,a=e.pstyle(o);void 0!==a&&(a=i.plainObject(a)?this.parse(o,a.strValue):this.parse(o,a)),a&&(n[o]=a)}return n}
```

--------------------------------

### Initialize Shopify Source

Source: https://github.com/xlang-ai/spider2/blob/main/spider2-dbt/examples/shopify002/dbt_packages/shopify_source/docs/index.html

Initializes the Shopify source with provided options. Use this to set up the source with custom configurations.

```javascript
var o = function(e, t) {
    var n, r, i = u(a.menuItemClasses), o = '<button id="' + e.id + '" class="' + i + '"';
    e.tooltipText && (o += ' title="' + e.tooltipText + '"'), e.disabled && (o += " disabled"), e.image ? o += '><img src="' + e.image.src + '" width="' + e.image.width + 'px"; height="' + e.image.height + 'px"; style="position:absolute; top: ' + e.image.y + "px; left: " + e.image.x + 'px;">" + e.content + "</button>" : o += '>' + e.content + '</button>';
    var s = t(o);
    return s.data("selector", e.selector), s.data("on-click-function", e.onClickFunction), s.data("show", void 0 === e.show || e.show), s
}
```

--------------------------------

### HTTP GET Request Example

Source: https://github.com/xlang-ai/spider2/blob/main/spider2-dbt/examples/shopify001/dbt_packages/shopify_source/docs/index.html

Demonstrates how to make an HTTP GET request using a factory function. It handles pending requests and response processing.

```javascript
function A(e){var t=\_({},e);return t.data=Fn(e.data,e.headers,e.status,r.transformResponse),qn(e.status)?t:u.reject(t)}}return y.pendingRequests=[],function(e){k(arguments,(function(e){y[e]=function(t,n){return y(_({},n||{},{method:e,url:t}))}}))}("get","delete","head","jsonp")
```

--------------------------------

### SQL Example: Using `expect_column_values_to_be_in_date_range`

Source: https://github.com/xlang-ai/spider2/blob/main/spider2-dbt/examples/inzight001/dbt_packages/dbt_expectations/docs/index.html

This example shows the `expect_column_values_to_be_in_date_range` expectation, which verifies that column values (dates) fall within a specified start and end date.

```sql
select * from {{ ref('my_model') }}
where not {{ dbt_expectations.expect_column_values_to_be_in_date_range('date_column', '2023-01-01', '2023-12-31') }}
```

--------------------------------

### Valid Table Path Examples

Source: https://github.com/xlang-ai/spider2/blob/main/spider2-lite/resource/syntax/bigquery_documentation/lexical.txt

Provides examples of valid table paths, including project, dataset, and table names.

```sql
-- Valid table path.
myproject.mydatabase.mytable287
```

```sql
-- Valid table path.
myproject287.mydatabase.mytable
```

```sql
-- Valid table path.
my-project.mydataset.mytable
```

```sql
-- Valid table name.
my-table
```

--------------------------------

### Pendo API Configuration Example

Source: https://github.com/xlang-ai/spider2/blob/main/spider2-dbt/examples/pendo001/dbt_packages/pendo_source/docs/index.html

Example of how to configure the Pendo source to use a specific API key and optionally set a start date for data extraction.

```yaml
vars:
  pendo_source:
    api_key: "YOUR_SECURE_API_KEY"
    start_date: "2023-01-01"
```

--------------------------------

### ViewService Initialization and Core Methods

Source: https://github.com/xlang-ai/spider2/blob/main/spider2-dbt/examples/quickbooks003/dbt_packages/quickbooks_source/docs/index.html

Demonstrates the initialization of the ViewService and its core methods for managing UI views and view configurations. This includes registering views, creating configurations, and handling synchronization.

```javascript
var s = function() {
    function e(e) {
        var t = this;
        this.router = e,
        this._uiViews = [],
        this._viewConfigs = [],
        this._viewConfigFactories = {},
        this._listeners = [],
        this._pluginapi = {
            _rootViewContext: this._rootViewContext.bind(this),
            _viewConfigFactory: this._viewConfigFactory.bind(this),
            _registeredUIView: function(e) {
                return Object(r.t)(t._uiViews, (function(n) {
                    return t.router.$id + "." + n.id === e
                }))
            },
            _registeredUIViews: function() {
                return t._uiViews
            },
            _activeViewConfigs: function() {
                return t._viewConfigs
            },
            _onSync: function(e) {
                return t._listeners.push(e),
                function() {
                    return Object(r.L)(t._listeners, e)
                }
            }
        }
    }
    return e.normalizeUIViewTarget = function(e, t) {
        void 0 === t && (t = "");
        var n = t.split("@"),
        r = n[0] || "$default",
        i = Object(o.l)(n[1]) ? n[1] : "^",
        a = /^(\^(?:\.\^)*)\.(.*$)/.exec(r);
        a && (i = a[1], r = a[2]),
        "!" === r.charAt(0) && (r = r.substr(1), i = "");
        if (/^(\^(?:\.\^)*)$/.exec(i)) {
            var s = i.split(".").reduce((function(e, t) {
                return e.parent
            }), e);
            i = s.name
        } else
            "." === i && (i = e.name);
        return {
            uiViewName: r,
            uiViewContextAnchor: i
        }
    },
    e.prototype._rootViewContext = function(e) {
        return this._rootContext = e || this._rootContext
    },
    e.prototype._viewConfigFactory = function(e, t) {
        this._viewConfigFactories[e] = t
    },
    e.prototype.createViewConfig = function(e, t) {
        var n = this._viewConfigFactories[t.$type];
        if (!n) throw new Error("ViewService: No view config factory registered for type " + t.$type);
        var r = n(e, t);
        return Object(o.a)(r) ? r : [r]
    },
    e.prototype.deactivateViewConfig = function(e) {
        a.c.traceViewServiceEvent("<-", "Removing", e),
        Object(r.L)(this._viewConfigs, e)
    },
    e.prototype.activateViewConfig = function(e) {
        a.c.traceViewServiceEvent("->", "Registering", e),
        this._viewConfigs.push(e)
    },
    e.prototype.sync = function() {
        var t = this,
        n = this._uiViews.map((function(e) {
            return [e.fqn, e]
        })).reduce(r.h, {});

        function o(e) {
            for (var t = e.viewDecl.$context, n = 0; ++n && t.parent;) t = t.parent;
            return n
        }
        var s = Object(i.e)((function(e, t, n, r) {
            return t * (e(n) - e(r))
        })),
        l = this._uiViews.sort(s((function(e) {
            var t = function(e) {
                return e && e.parent ? t(e.parent) + 1 : 1
            };
            return 1e4 * e.fqn.split(".").length + t(e.creationContext)
        }), 1)).map((function(r) {
            var i = t._viewConfigs.filter(e.matches(n, r));
            return i.length > 1 && i.sort(s(o, -1)),
            {
                uiView: r,
                viewConfig: i[0]
            }
        })),
        c = l.map((function(e) {
            return e.viewConfig
        })),
        u = this._viewConfigs.filter((function(e) {
            return !Object(r.z)(c, e)
        })).map((function(e) {
            return {
                uiView: void 0,
                viewConfig: e
            }
        }));
        l.forEach((function(e) {
            -1 !== t._uiViews.indexOf(e.uiView) && e.uiView.configUpdated(e.viewConfig)
        }));
        var d = l.concat(u);
        this._listeners.forEach((function(e) {
            return e(d)
        })),
        a.c.traceViewSync(d)
    },
    e.prototype.registerUIView = function(e) {
        a.c.traceViewServiceUIViewEvent("->", "Registering", e);
        var t = this._uiViews;
        return t.filter((function(t) {
            return t.fqn === e.fqn && t.$type === e.$type
        })).length && a.c.traceViewServiceUIViewEvent("!!!!", "duplicate uiView named:", e),
        t.push(e),
        this.sync(),
        function() {
            -1 !== t.indexOf(e) ? (a.c.traceViewServiceUIViewEvent("<-", "Deregistering", e), Object(r.L)(t)(e)) : a.c.traceViewServiceUIViewEvent("Tried removing non-registered uiView", e)
        }
    },
    e.prototype.available = function() {
        return this._uiViews.map(Object(i.n)("fqn"))
    },
    e.prototype.active = function() {
        return this._uiViews.filter(Object(i.n)("$config")).map(Object(i.n)("name"))
    },
    e.matches = function(e, t) {
        return function(n) {
            if (t.$type !== n.viewDecl.$type) return !1;
            var i = n.viewDecl,
            o = i.$uiViewName.split("."),
            a = t.fqn.split(".");
            if (!Object(r.q)(o, a.slice(0 - o.length))) return !1;
            var s = 1 - o.length || void 0,
            l = a.slice(0, s).join("."),
            c = e[l].creationContext;
            return i.$uiViewContextAnchor === (c && c.name)
        }
    },
    e()
}

```

--------------------------------

### Example Model Name with Project and Dataset

Source: https://github.com/xlang-ai/spider2/blob/main/spider2-lite/resource/syntax/bigquery_documentation/bigqueryml-syntax-create-glm.txt

When a default project is not configured, prepend the project ID and dataset to the model name using the format `[PROJECT_ID].[DATASET].[MODEL]`.

```sql
`myproject.mydataset.mymodel`
```

--------------------------------

### SQL Example: Using `expect_column_values_to_be_in_datetime_range`

Source: https://github.com/xlang-ai/spider2/blob/main/spider2-dbt/examples/inzight001/dbt_packages/dbt_expectations/docs/index.html

This example shows the `expect_column_values_to_be_in_datetime_range` expectation, used to check if column values (datetimes) fall within a specified start and end datetime.

```sql
select * from {{ ref('my_model') }}
where not {{ dbt_expectations.expect_column_values_to_be_in_datetime_range('datetime_column', '2023-01-01 09:00:00', '2023-12-31 17:00:00') }}
```

--------------------------------

### Example: Staging Users Model

Source: https://github.com/xlang-ai/spider2/blob/main/spider2-dbt/examples/pendo001/dbt_packages/pendo_source/docs/index.html

This SQL snippet defines a staging model for Pendo user data, selecting and preparing user-specific attributes.

```sql
-- models/staging/stg_pendo__users.sql

select
    user_id,
    account_id,
    user_email,
    created_at,
    last_seen_at
from {{ source('pendo', 'users') }}

```
Tokens:
Raw