Best Practices

Work In Progress

Push down computation

• Push data processing to SQL or Spark or Model Serving.

• Parameterize your queries and be careful with SQL Injection.

• Cache frequently used result sets.

Authentication

When to use user authorization:

• Queries in which data visibility must adhere to the user permissions.
• Any create action in which the object must be owned by the user.

When to use service principal authorization:

• Any background processing.
• Any long-running task.
• Any create action in which the object must be owned by the application.

Versioning

Mount versions of the app together using different paths