Tracking SQL functions in Hasura

Postgres: Extend Schema with Custom SQL Functions - Hasura

Track SQL functions ... Functions can be present in the underlying Postgres database without being exposed over the GraphQL API. In order to expose a function as ...

Tracking SQL functions in Hasura - Stack Overflow

I am trying to calculate the similarity of the jsonb rows of 2 users with a very simple SQL query as such:

Using Custom SQL functions for queries with Postgres and GraphQL

Directly query custom SQL functions in GraphQL API. ... Once you've created and tracked this function (using the Data -> SQL section of the Hasura ...

Metadata API Reference: Custom Functions | Hasura GraphQL Docs

pg_track_function is used to add a custom SQL function to the GraphQL schema. It supports more configuration options than v1, and also supports tracking custom ...

Schema/Metadata API Reference: Custom Functions (Deprecated)

Track/untrack a custom SQL function in the Hasura GraphQL Engine. Only tracked custom functions are available for querying/mutating/subscribing data over the ...

Hasura complains about stored proc being not trackable because it ...

https://hasura.io/docs/latest/graphql/core/databases/postgres/schema/custom-functions.html#track-sql-functions. Check the notes in that link ...

Hasura Postgres Functions Guide — Restack

To create a custom function in Postgres, use the CREATE FUNCTION SQL command. This function can then be tracked by Hasura, making it available in your GraphQL ...

track functions that return a single row · Issue #4299 - GitHub

... hasura.io/docs/1.0/graphql/manual/schema/custom-functions.html#supported-sql-functions We can extend this to functions that return just a ...

Schema API Reference: Run SQL (v2.0 and above) - Hasura

While run_sql lets you run any SQL, it tries to ensure that the Hasura GraphQL Engine's state (relationships, permissions etc.) is consistent i.e. you cannot ...

Postgres: Computed Fields | Hasura GraphQL Docs

Functions used as computed fields do not need to be tracked by the Hasura GraphQL Engine. As the requirements for tracking functions differ from those to add ...

Postgres function examples for Hasura - Restack

Exposing Functions to GraphQL. After creating the function in your Postgres database, you can track it in Hasura to expose it as a GraphQL query. Navigate to ...

Postgres: Native Queries | Hasura GraphQL Docs

Use the full power of SQL that Hasura might not provide access to through the typical table API, such as GROUP BY , window functions, or scalar functions.

MS SQL Server: Stored Procedures | Hasura GraphQL Docs

Stored procedures can be used to track MS SQL Server stored procedures and execute them via the Hasura GraphQL Engine. ... SQL functions and operators. Stored ...

Postgres Custom Functions | Hasura GraphQL Docs

They are typically used for performing custom business logic in the database. Refer to Custom SQL functions and Computed fields for more use cases and for ...

Postgres: Tables Basics | Hasura GraphQL Docs

When a table is created via the Hasura Console, it gets tracked by default. You can track any existing tables in your database from the Data -> Schema page:.

Postgres: Extend Schema with Views | Hasura GraphQL Docs

Tracking views ... Views can be present in the underlying Postgres database without being exposed over the GraphQL API. In order to expose a view over the ...

Build a GraphQL Application Using Hasura - CockroachDB

In the Hasura Cloud Data Manager click public under your connection name. · Click the Track All button. · Click Yes when prompted to expose the table to the ...

hasura/graphql-engine v2.0.0 on GitHub - NewReleases.io

server: support tracking of functions that return a single row (fix #4299); server/mssql: supports connection pooling to sql server; server: improve errors ...

Data Transformations in Postgres | Hasura GraphQL Tutorial

We are going to leverage Postgres data transformations using Views and SQL Functions to find online users required for the app. ... Let's add this view and track ...

Using Hasura To Build Core Platform - Teaching Strategies

The last way Hasura enables us to build our core platform is through change data capture (CDC), or the process of tracking changes to a database ...